Search results

If you use some code that is on this website: http://www.btabdevelopment.com/ts/default.aspx?PageId=48 you can modify it to do the formatting for you as well as do the export.

Private Sub submit_button_Click() Dim response As Integer response = MsgBox("Are you sure you want to add this new client?", vbOKCancel, "Confirm adding new client") If response = vbOK Then DoCmd.Close acForm, "addClient", acSaveNo Else Me.Undo DoCmd.Close acForm, "addClient"...

What documents? Word Documents?

Did you change this database from an mdb file to an accdb file? If so, how did you do it? The best way I've seen is to import everything into a brand new database shell and to not use the save as feature.

See if this works instead: INSERT INTO CUSTOMER_LIST ( First_Name, Last_Name, Zipcode, Phone_No, Email, Referred_By, Referrer ) VALUES ( [Forms]![AddEmployee]![First_Name], [Forms]![AddEmployee]![Last_Name], [Forms]![AddEmployee]![Zipcode], [Forms]![AddEmployee]![Phone_No]...

An ACCDE is compiled so it can't create certain objects. It would appear that is your problem. It really depends on what the add-in is creating. And, of course we don't know that because we can't see the code for the add-in.

What is the SQL of the query?

A couple of things. 1. it is x86 not x84 2. and if you have a database that is running in x64 OFFICE then it will not be immune from having to have changes. If the 32 bit of Office or Access is installed on WINDOWS 64 bit, the database should work fine. If you have built a database with 32...

FYI for rodmc: It is a common misunderstanding that you have to open a select query in order to "refresh" the data so it can be used in another query or report. You do not have to do this. You open the final report, based on the query (or report with subreports based on multiple queries) and...

Use the free V-Tools which has Total Deep Search and that can help you find any reference to that form.

Bob Larson has code for doing just this thing. You would set your query to be whatever month you need and then export it using this code. You can iterate through to get the whole thing done if you want.

Well, not really but I did have to set up a VB6 install program so it would install the control I needed to any new workstation that might need to use the program.

I'd go with Linq's suggestion over using an ActiveX control. I avoid them like the plague if I can. I don't like using ActiveX controls because I've run into too many problems between machines with them and so unless I absolutely have to (and I did in one case using an Inet control for...

Why not just set up a combo box on the main form to select the record you want? You can even use the wizard to set it up for you. Or are you wanting to be able to search by different parts? If that's what you want, why not just use the Query By Form method. You can set up a button to activate...

Wow, who would have thought about that question to ask?

Including the fact that it isn't installed on every machine, so you would have to do so. And, for example, I can't even find it on mine even though I have VB6 installed. It isn't in my ActiveX control list (unless I'm looking for the wrong name).

And use NZ so that if there is a null it won't honk everything up: =Nz([Total1],0)+Nz([Total2],0)+etc

Glad that worked for you.

Tried what out? The TransferSpreadsheet? That would export all items unless there was a way to limit it. The code I referred to should work on a filtered form.

Your problem is that you aren't getting the ID value from the listbox. You are getting the FY10_CLS_SSP_Title, so if you double click on "Golf" you are trying to find a record based on Golf, not the ID. You need to add the ID to the listbox's rowsource and then reference the applicable column...