Search results

I have been trying to do something, and I dont know if can be or not. I have a main form, FormA that has a unbound subform we'll call sfrmA. I also have sfrmB. I would like a command button to change sfrmA to sfrmB. I got this working having the command button on the main form (FormA). Is...

Hey Bob, I have an update query like this. My query pulls up information that needs to be printed, I then choose which ones to print and when my update query runs it changes my yes/no field to yes it was printed. My question is what if a user make a mistake after firing the code and decides...

Thanks, for the responses. I have some reports and queries where I use combobox and options to show/hide data that I want...The funny thing is when I first started that same report involved 20 reports and 20 queries. Using that technique I cleaned up quite abit. It just seems like I am using...

3 years ago I started on a access project. Throughout that time my dB has grown from 3 tables for one job to over 30 for multiple, because I saw the "power" of how I could track anything I wanted and built it to work for my business. I can honestly say that I think it's normilized to the best...

The problem was completely understood, and a link was included in my first response. This solution is fee based and provides a license that offers a number of days trial, 1 time purchase, or yearly renewal.

After importing I did get a compile error refering to ' build our merge file, and write a "csv" file to disk Dim strDirPath As String ' full path name to working dir Dim OneField As DAO.Field ' dao code Dim strFields As String Dim strData...

Try the form's searchtext field's on change event From: Me.Results.Requery To: DoCmd.Requery "Results" And see if that works

your attachment works for me. what seems to be the problem?

If I am thinking correctly, you will need to make sure that the user has access installed on their machine in order for them to use your application, at the very least the runtime. Microsoft has released the runtime version for A07 as a free download, and version prior to that you would need...

Ok, thanks - I will give it a shot and let you know, will be this evening before I update. Thanks again for the link to your tips page. ***Edit*** I ended up having to do the solution OOI posted on the audit trail thread. Change my lookup field's name.

Tony those were great videos! Do you think I could be able to also use the audit trail by doing these changes? thanks gerald

Sorry...I guess it wouldve helped if I mentioned the form name on northwind. The form I make reference to is the orders form, in which the user may use a drop down box in order to select a customer based on name. When a name is selected it auto fills the contact information and other...

Thanks for the link. I think I know what must be done. I have a question though which I am sure you'll know. Is there a way to get the same effect on a data entry form as what is on northwind? I realize know that may tables are not exactly set up right with the look ups, and I have spent...

I am now a bit confused. I used the Lookup wizard on my tables to establish the foreign key, is this not the correct procedure? Should I have set relationships on the screen where it shows the relationships and types? I modeled my db's main data entry form after northwind's orders form. I...

Great, I never saw this before, now I am thinking that my database, which i have loved and nourished for two years is now going to bite my butt.:(

I hate to bring another Audit Trail question to the table, but I am scratching my head for thelast day trying to get to get this work. Link to original post: http://www.access-programmers.co.uk/forums/showthread.php?t=44231&highlight=audit+trail Problem: I have a main form/subform. The...

I searched google for this: http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true

Someone may add to this. Access 2007 runtime is now a free download from microsoft, that would be installed on your local machines. You would split the db into a fe/be and load the FrontEnd on every machine linking to the BackEnd on your main server. You might also want to look at error...

See Attached I kinda ripped it up a little bit. but, I added a unbound text box to your frm Search mirroring the voucher number on frmsubclients. I created another query where the criteria matches that unbound text box and used this query to run the report. You can make the text box...

I found this while Searching keyword=secure http://access-programmers.co.uk/forums/showthread.php?t=95390&page=2&highlight=secure