Search results
-
C
Input form that does not show exisiting records
Hello, I need to create a blank form that is soley for input. It will update a table. My issue is that I do not want the form to display any of the existing records in the table. i just want a blank form for capturing data. Any thoughts on how to do this? Thanks Cindy -
C
Lookup without code
Hi There, I am trying to create a form that has a text box. I want to be able to input a value into that text box and have it lookup whether that ID exists in my table. If it does I would like it to open a form that is populated with that ID and relevant information. If the ID does not... -
C
duplicates in query result
Sue, I noticed your reference to Gold Creek and Alouette Lake in your data. I am assuming Maple Ridge. I am a former resident and this caught my attention. I never quite expect to find a forum to be a small world. -
C
Export Report to HTML, customize name
Hello, I have a report that displays invoices/bills. Each page breaks on customer, so 1 page per customer. (In my instance I have 42 customers and 42 pages in my report) When I export this report it created 42 HTML documents, which is great, exactly what I need. Now the naming of the reports... -
C
Form validation rule
Acutally my form is a Parent and Child form. The Parent form holds the user is and the subform holds the detail. The Parent form is based on a query that prompts the user to enter their id. So how can I work the macro into this scenario or do I have to write a macro as well to prompt the... -
C
Form validation rule
I have a databse built to use as a survey tool. The survey is to remain annoymous so I have built an ID table with some random id numbers that will be distributed in envelopes. I have tables built on areas and in those tables I have the various questions and ratings built in. I have a query... -
C
Multi-Table Query and Calculations
I have two tables where I would like to subtract field values in one table from field values in another table. Once the calculation is done, I want to take the result and perform another calculation on them EG: Answer =[TABLE1]Field A - [TABLE2]Field A Answer2 = Answer X 1.5 Does anybody... -
C
Query Calcations
I am using Access 2000 I need to subtract fields in one table from fields in a completely different table. Once each of these pairs of fields in different tables are calculated, I need to take the sum of each pair and multiply each of them by different values. Does anyone know how I would go...