Search results for query: *

Hi Ken, Heres the deal...each site has its own separate database. The problem is that once the form is created, it would need to be distributed to each of the 1500 sites. You are correct, all the processing occurs on "b", but the form has to be created/exported in each site first. I...

Hi Ken, Thank you for your quick response. This query is used via PCAnywhere over a satellite connection to more than 1500 locations. Currently the SQL text has to be pasted into a new query at each location when it is needed. I don't think its possible to export a form without copying the...

I am using the following query to select qualifying records: SELECT tblOrder.OrderNum, tblOrder.CloseTime, tblOrder.BusinessDate FROM tblOrder WHERE (((tblOrder.CloseTime) Between #2/11/04 4:01:00 am# And #2/12/04 4:00:00 am#)); Since my users are not very adept at writing queries, I want them...

Simon you are an AWESOME individual!! I tend to do things the hard way, so this was a big change of pace for me. Thank you for the help!!!

I am working with an Access97 database that I did not write, but need to edit large amounts of data in. The two columns of interest are adjacent to each other. The first column contains a valid date but the second does not. Column 1 Column 2 6/16/2003 12:16:12 AM...

Thanks Dreamboat, yes I have tried it in design view. Nothing happens when I right click or double click. I can create a new combo box and edit the code no problem I just can't get to the existing combo box code. The spread sheet is not protected. I'm usually pretty good at figuring out this...

I have inherited someone elses spreadsheet. It has a bunch of comboboxes embedded in it, but right clicking on the combobox doesn't do anything. Even in VBA edit mode I still can't get to the code. I'm pretty sure they are form controls and not active-X. I can insert a new combobox, right...

Thank you for the assist Maq. Your great. Saxie1

I've looked through all the help files but can't find anything on this. In Access97 I want to have a combo box with two columns, one with abbreviated month, the other spelled out. What is the syntax to reference the second (unbound) column, so that I can click "Jan" and put it in a...

Has anyone else had a problem with the calendar working great for a few weeks, then suddenly just quit working? I haven't figured out what is causing the calendar to transfer dates correctly to a table one day, then not transfer any dates to the table at all. If anyone knows how to correct this...

Try this one.. Create a Command Button and paste this code in the on-click action. _________________________________ Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70...

Thanks DougP. Your right it doesn't work very well, I'll keep playing.<br>Saxie1

From the print preview screen, I have my report set up to print OnClose. What syntax do I use to print only the record currently displayed, not the whole report?<br> In MsWord I know I can use<br> <br> PrintOut Range:=wdPrintCurrentPage<br> <br> to do what I want, is there a similar command...

Lehtoant,<br> This Dlookup article looks like exactly what I need. I haven't actually tried it yet, but it looks very promising. Thank you so much for taking the time to answer my cry for help.<br> Saxie

I am using an option control to set the value of a text box in a form. When I add the record to the database the value transfers to the data base but the text box goes blank for the next record. How do I get the textbox value to stay the same in the next record unless the user changes it? This...