Search results

The windows clock reads the BIOS clock, they are the same. If a user changes the time via the system tray, it changes the BIOS clock.

I have A2003 on WinXP. I'm looking for a website which has a FAQ grouped by form controls. So if I have a question about ComboBoxes, I could go to this site, go to the ComboBox section, and look at the FAQ before posting here. Any ideas?

A2003 on Win XP. I have a form with 2 list boxes, both with the same columns in the same order. When the user double clicks on the first list box, I want to copy all columns of that row to the second list box. This should be a one line deal in A2003 but I can't seem to figure it out using...

I have A2003 on Win XP. I swear in A95 or A97 there used to be a method to clear all items from an unbound ListBox. Now in A2003 I used help and do not see anything like that. Is there a preexisting method to clear all data from a list box?

I have Access 2003 on Win XP. I am using a ListBox control on a form. I can create multiple columns but cannot resize the columns. My data source is a value list, populated via VB code. Is there any way I can let my users resize columns? Data may be too large to fit with the preprogrammed...

The Autoexec macro can be used to run any thing, even VBA code, each time the MDB file is opened. I use it to open my main application form using Form Open.

As we get older, our eyes aren't so good. I have Access 2003 on Win XP. How do I change the default font and font size for all MsgBox functions? Thanks.

I think your "DoEvents" line is causing VBA to continue without pausing. Remove that loop with "DoEvents" and try again. Or maybe VBA has a Sleep or Wait command.

There is a property in a Combobox, I THINK, that allows you to select multiple records in it. If not, use a ListBox, which I know does have the SelectMultiple property. (I think it's called SelectMultiple.)

Thank you.

Tony, I think you have just discovered that when you use the wrong tool for the job, you will come across limitations. Perhaps if you used MS Access to grab the data from Excel, you might have more flexibility. I used MS Access to make HTML pages based on the contents of a table. Access writes...

Excel 2000 on Windows I have a very wide spreadsheet, as such, I have to shrink it down to see more columns in the window. As my cursor moves around in the spreadsheet the row and column labels are bold. My old eyes would like the whole row to be highlighted with a certain color as the cursor...

Thank you!

We are paid every week, so this week we are running payroll for last week. Our pay period is Sunday to Saturday. Given today's date, how do I find the date of the just past Sunday? If I can find the previous Sunday, I can subtract 7 days and get the begin date of the current payroll period we...

Thank you for the Nz hint. I think the problem is solved.

Ok, when I use =Dsum("[PROCHOURS]", "tmpHours", "[Payable]=True") as the ControlSource for txtWorked, I get what appears to be correct hours. But when I use something similar for txtDoctor, I get nulls, even though I checked that some people (namely me) have doctor hours in the table...

(Sorry, I want to SUM hours by EmpNum.) I have a table, tmpHours, which contains these fields: EmpNum, PROCNO, HOURS, Payable It contains multiple entries per person, per day, or hours worked by Process Number (PROCNO). Some PROCNOs are payable, some are not. Some PROCNOs are special, like...

I STRONGLY agree on both counts. Especially, as I am a user of unix, Windows, and Mac systems, spaces in filenames can cause uncountable headaches. Stick to only letters, numbers, dashes, and underscores in filenames and you'll be safe. While an OS or software package claims it supports spaces...

Rs2 and Db could be global variables, but the OP did not say that.

Wouldn't this work also? docmd.execute "file.pdf" This should run the program associated with the file.pdf and open file.pdf. My question is, does Docmd.Execute handle spaces in the path correctly, or at least better than Shell?