1,597 Topics
 | |
| | I have been working on a program designed to read information from an Access database and display it on the screen. As my main development box doesn't have a copy of Access on it, I copied the data over to a PostgreSQL database and attempted to work from that. Now, …  |
| | Hello to all. I saw a post about multiple imports from a folder into Filemaker. I plan to give it a try soon. What I am curious about is there a way to Filemaker automatically import the files from a folder. This could be a once a day or once … |
| | hi could u give me the code to open PDF file, or open a folder ?Thax |
| | I am using SQL to write to an MS Access db via JDBC. Whenever the word or word-portion "update" occurs within a text string I am trying to store, I get an error message that "update" is a reserved word, even though it has been correctly delimited (such as 'xxx … |
| | I have recently updated from Office XP Developper to Office Professional 2007. Although I have navigated a lot in the "Help" documentation of ACCESS 2007, I could not find any instruction about how to join a Workgroup (xxx.mdw) used by my protected ACCESS 2002 Databases. Therefore I cannot open them. … |
| | Using FileMaker Pro 8 I have a table whit a column for dates, like showing below. dates Mon, Sept 10, 2007 Wed, Sept 12, 2007 Wed, Sept 19, 2007 Mon, Oct 8, 2007 Mon, Oct 15, 2007 I want a field(s) to show all those records like this Sept 10, … |
| | hi every one, i have an application in which i have to send email alerts to a student untill he pays his feez.we are using windows 2000 professional and outlook 2003,msaccess 2003.Iam new to using msaccess,can anyone give the detailed procedure on how to send automated emails using macros or … |
| | I just found an easiest way to save your documents. It can then process this data as well to create quite complex filing systems.[URL="http://www.awgarstone.com/product.php?item=activefiler"]Activefiler [/URL]could be easeasily be used from any Office program, or any program that can call a DLL as it exposes a full API.You will need to … |
| | How is the best way to back up Outlook 2003 Contacts. I want an external back up that I can transfer contacts to another computer and do it daily if need be. |
| | Hi All, I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit? |
| | Hi, I'd really appreciate some help from the access/db gurus out there. I've got an access 2000 database, on a WIN2K machine, which has linked tables to a Sybase db, connecting through a Sybase ASE ODBC driver. I find that everytime i try and get data from the linked table …  |
| | ...sorry, posted the same question. ...still getting the hang of things. |
| | I created a Microsoft Access 2003 database that conatin photos stored as Long Binary data. I want to be able to merge those photos into a Microsoft Publisher 2003 document as a photo. Just don't know how or if I can. Can anybody give me advise? |
| | A friend recently approached me to transfer her Filemaker pro data into MS Acces03. That was easy enough until she asked me to duplicate the same "find mode" capabilities in MS Access. Searching various forums and sites, it seems like it can't be done. the closest i got in MS … |
| | Its' quite a long question but I've explained it the best way I know how I have two subforms within a main form. Each of the subforms are not directly related at the table level. one subform is for project payments, the other is for the project bank details. Because …  |
| | Hi there. I'm looking for a bit of advice. I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo. The advice I'm … |
| | Hi, I wondered if I should set "replication ID" for field size for the foreign key? The field size is courently set to "long integer". What is bether to use, why and what is the difference? Thx for your help. |
| | I would like help with MS access iif statement. I want to group courses but day offered e.g Monday, Tuesday, Wednesday, etc and by time offered e.g Monday: 6:00 PM - 9:20 PM. I have an iif statement which should convert the letter (day) to worrd e.g, M to Monday … |
| | hi all! I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999. Thanks |
| | Hi, I have a parameter queery which asks for "Name " . I want to Enter a few characters and find similiar full names to it which are in the field "Names". For example: If I type chr it should find out "christine" Pleae help Best regards Nadeem |
| | [code]Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _ & "FROM Members " _ & "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")[/code] This is my query in VBA in MSAccess. I just want the number of people that fall into those … |
| | I am a new user of FileMaker Pro. I am converting an MS Access database and am stuck on including multiple tables in a format. How is this done? |
| | I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed … |
| | Has any body used the Professional suite of products for FileMaker released by FusionCharts Team? [B]FusionCharts Pro for FileMaker[/B] is the FileMaker charting tool and [B]FusionMaps Pro for FileMaker[/B] is used to create flash maps within FileMaker solutions. As both the products use built-in features of FileMaker; people having knowledge … |
| | I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell … |
| | hi Friends! i need to open a pdf documents from MsAccess. Please send me the code. Then i need to create a BROWSE button such that BROWSE_BUTTON Text_box When i click the browse button it should work as ordinary windows browse button and when i select some files, the "File-Path" … |
| | Hello please help me to calculate this one: I have a table containing this fields (name, project done, hours consumed) example: this is a table of a timesheet [code] [COLOR=green][LIST=1] [*]--------------------------------------------------------------------------- [*]| NAME | PROJECT DONE | HOURS CONSUMED | [*]-------------------------------------------------------------------------- [*]| A | 1 | 5 | [*]| B … |
| | I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Table2 -Deal -price Query1 -Model (this is in a query as it has been split from … |
 | hi, i am great at php but completly new to microsoft access databases, could someone explain simply how to make one, or give me a link to a site which explains plz???  |
| | he y pls any one help meee in linking html with ms access.... i have noo idea about how to link html with ms access....  |
| | I have 2 problems I need your help please: 1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information …  |
| | I'm trying to keep a date in a subform. Once the user enters a date and the procedure done on that date, he clicks on Add Record button and all the fields in the sub form are blanked out. I need the date to stay the same so the user … |
| | I want to share a resource with all the FileMaker users and I am sure that this will help us professionally. FusionCharts Free for FileMaker has been released. This helps to create data-driven flash charts inside FileMaker solutions without installing any external plugins, drivers or server software. Since it uses … |
| | Hiz people ....after a day i m having pracitcal exma....n they have said me to make a database....so i decided to make student database of my school.....very simple so that sir wont ask me hard questions....so plz i think i donno some steps in completing my database....can anyone help.... for … |
| | I am working in ms access database2000 and my frontend is vb 6.0. I have three tables namely:- AREA:- areaid,areaname ROUTE:-routeid,routeno,routename,areaids PARTY:-partyid,lastname,firstname,address,areaid The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,' The problem is that i want to derive …  |
| | Hi, I'm creating a customer database in MS ACCESS with the following 3 tables: Customer (with unique customer_id) Products (with unique product_id) Customer_Order(contains both customer_id and product_id). I want to be able to use a form to enter new information into both the customer table and the customer_order table. The … |
| | I am supposed to create a hotel reservation system that allows you to make a reservation either with a hotel package or without and calculate billing. However I am at lost for where to begin. I have made a couple of sorry attempts but I am having problems identifyind the … |
| | How do I limt the records extracted from filemaker using the query "Select.... LIMIT 5" ? Example: select * from tablename limit 10. I connect the filemaker pro 8.5 via ODBC and use php to display the records.A small amount of records(1 or 2 rows) will display the records, but … |
| | I have a simple form that I want to have generate a random password, I just need it to generate the password, The database user will then copy the password and paste it where she needs it. The main issue I don't want her to have go to a web … |
| | i would like to query a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when goes to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this? |
 | I really need some help here and hope there are some Access database whizzes out there...and i know...there are.... my friend and I are doing a database project for a health care service... and we are trying to use the expression builder to perform calculations But for our fields, we … |
| | hello im preparing a chemical database where i need to store chemical structures. ASP as front end i want that when the user draw a structure(user will manually draw the structure) in frontend there should be a search in the database for similar structures and all the similar structures should … |
| | I am done wracking my brain on this one, so if anyone has an answer I would be most grateful! I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields … |
| | Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each … |
| | hi i don`t know if this is the right forum for this but its an emergency.... does anyone know how to add pictures to MS Access database!! like, to add a column called pictures and under that column we have all the pictures displayed!!! plz HELP |
| | I have an Access 2002 managed replica set running on about 80 sites which communitcate via Indirect Synchronization with a hub replica on a server in a State Government network. Some users are connected directly, some are on DSL and some of us are on satellite or even dialup. All … |
| | How do I select more than one data option from a look-up and save these options into a list box or combo box please? Newbe:| |
| | [COLOR=#008000][COLOR=#000000]Hi, please give me the script (syntax) and place, to be written it in a form in ms access 2003. [/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]1. Text box1 should be displayed the value of field[B]1[/B] from table [I]randomly[/I], when I click the command button1.[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]2. Text box2 should be displayed … |
| | I have a Access 2003 database which has a table we'll call orders. There are 10 other tables linked to orders through Order_ID. I'd like to be able to create a duplicate of a record and all the associated records in the linked tables. I've read it possible with an … |
| | I am using Access 2007 to try and calcualate the difference between two time fields and when I enter in the validation rule I receive the following error! I do not have the field indexed. "Invalid SQL syntax error - cannot use multiple columns in a column-level CHECK constraint" Can … |
The End.