Search results

I have a relational db with several tables in it. Each of these tables contains controls for people's names. I need to build a master name index that returns the results of all names in the tables based on a search. I tried to do this in a query but only the tables that are linked come back...

I'll give it a try. Thanx for responding. This has been driving me nuts!!!!!!!!!!!! Marty

This has been viewed 70-some-odd times. Someone must be able to help me out here? (Notice how I keep adding stuff to keep it on the front page - that's because I'm desparate) Please. Thanx Marty

Can no one explain this? Surely I haven't stumped everyone. There must be a simple solution to this but I can't find it. Please help! Marty

Not sure what you mean by the Has Data method. I dont find this on the main report. Could you further explain? Thanx. Marty

I tried that in the sub report NoData box and in the main report NoData box. Neither way works. I dont know why but it is buggin the s--t outta me. Help? Marty

I have designed a report for printing based on multiple tables. This Main report contains two subreports that are linked by main report number. The sub reports are based upon tables and again are linked by main report number. When there is data in all of the reports for a particular record...

No, briefcase is not an option. The laptops are secured in the vehicles. Running Windows 95 for most part and using Office 97. Looking for way to dump down to a floppy disk, maybe just the tables to import to the database on the network system? Just not sure where to start. Thanx. Marty

I have a database for multiple users. This database resides on the network system. However, most of the users are in the field with laptops. I want to copy the database onto all of the laptops (about 15 total) so that the users in the field can input records. However, I dont know how I can...

Open the form in design view (the main form with case #, etc). Assuming you have already built the other forms, use the command button to "Open Form" and set the criteria using the wizard to open using specific data. (Make sure the wizard icon is toggled). Follow the instructions and link the...

Try building a form for the first table (Customer info). On this form place a command button to the Payments table form (which you need to create). Follow the instructions for the command button and select the criteria that will link (I suggest either linking by Customer last namde or even...

If you are using a form open the form in design view. Click on the command button and follow the links to form operations. Select "New Record" and you'll have it. Marty

Someone helped me a while back with password protecting a form. It worked great. But I need to know if there is a way to block out the typed-in password (such as **** with input mask). It would be easy if it were in a table but it is not. Anyone able to help me out again? Marty

I have a db I made for work. It is a flat file db that users can enter records. On this flat file db are several fileds that are used to put names, addresses, phone numbers, etc. I built the table using name1, name2, etc, address1, address2, etc. There are five of these. I built this db a...

Can I make a suggestion? Why dont you use the date fileds and build a query to run a date range. Use this query as the control source for a copy of the form you use. By doing so you can not only get your averages by the week, but for any week, month, quarter, or whatever time period you...

Make the month field in tables a combo box listing all the months. Then build a query and set the criteria to run based on data input (month). Leave the rest as you have it. This will run the query based on the month and you can then set the fields you need in your report. The report control...

Does it come out the way you want it to in the table? If so then you need to format the field in your report the same way. If it still doesn't work try formatting the fields in a number format. Marty

I got it. Don't know where I left my brain. I forgot how simple it was until I looked at it for a minute. Tried to overcomplicate things. Unbound form, create unbound text box in report, link these boxes to the fileds in the unbound form fields. Create command button to open the report...

I meant to say I created a "Report" that has a table as its record source, not form.

I have a report that contains mostly text with only several fields. I need to fill in address information that is not stored as data in the database. I have created the form using a specific table as its record source and then created unbound text boxes. The drawback is that the text boxes...