I run a query that tells me what vehicles are down for repair. That query is run against the VehicleID table and the vehcile history table and it works well....
Fairly simple; 2 ways come immediately to mind. Best is a LEFT JOIN, which the unmatched query wizard will lead you through. Less efficient would be a...
Norhaya Formatting is most easily done in the form or report text box. Your example did not actually display properly in the email. Can you describe in words...
Thomas I see that no one has responded to your post. If I remember correctly, the ability to use Access on handhelds was dropped. But I could very well be...
Hi: How to i union both queries. Both queries match record from tabl tech_id. This is the result which i need. First 2nd query run and match with table...
Salena lux
salena.rose@...
Oct 1, 2006 5:05 pm
41715
Dear Group, My searchResult form is based on a parameter query. The parameters are passed to qrySearch through Search form. The qrySearch is based on...
Hi Folks, I'm new here and I have what is probably a simple question. I need to produce a report from a maintenance database. Two files are involved, the...
Kumar- A command button is easiest. In the Click event of the button use DoCmd.OpenForm with a WhereCondition to open another form bound to the table ...
Katrina- With a query something like this: SELECT tblBuoys.*, tblBuoyData.* FROM tblBuoys INNER JOIN tblBuoyData ON tblBuouys.BouyID = tblBuoyData.BouyID WHERE...
I see the option to upsize to Microsoft SQL Server is available even back in Access 2000. Can someone take the mystery out of the process for me. Is this a...
Hey Christopher, * Is it worthwhile? SQL Server is industry standard backend technology with a huge install base. Worthwhile features vs Access are that it's...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Oct 2, 2006 5:55 am
41722
Linda, As mentioned earlier, reports sent directly from Access to Excel are known to suffer from the following shortcomings, making the outcome quite...
I'm brand new to this list and I'm wondering if you could just point me in the right direction. I've searched the Access help and Googled till my brain is...
Brett- The consensus I've seen online from other MVPs is that staying with an mdb front end with linked tables is the better / faster / cheaper way to go to ...
Dear Mr. Tejpal, Many thanks for your guidance and sample coding. I was precisely looking for this type of functionality in my database. I will try it out and...
Mike- The trick is to open your code and choose References from the Tools menu. Scroll down the list and select the checkmark box next to the Microsoft Excel...
Hi TJD, I tested your tip and is working fine. Do I have to create separate tables for each combobox of my searchForm or one table with fields for each search...
A book that I found very useful for a project that I did is: Integrating Excel and Access by Michael Schmatz, from O'Reilly Regards, CJ ... [Non-text portions...
I think my table structure may be a little too 'flat'. I have basically 1 big table, 1 main form and several subforms which are necessary because one form...
Hi Eddie, I am just now testing this. Please forgive me but I am an absolute beginner with VBA. When I try to run the code in the vb window another window...
Gav- You're getting the "write conflict" because you're trying to edit the one table from two forms at the same time. You really need to fix your table design...
Gav Without even seeing your design, from what you are saying, you need to read up on normalized tables. We have a link or 2 in our links section that should...
Thanks for the feedback, everyone! I didn't want to change the References since I'd never know the environment it would be running in. I finally found some...
hi guys, im just a beginner with using access and i only know the basics. How do you create a simple password for a form with a only 1 user? Thanks guys, help...
Hi, Norhaya, If it is either a form or report you are formatting, there are two easy ways to do it. First is have the Formatting toolbar showing. To do this,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
