Search results

Yes it does! I've just tried it.

Select an Input Mask and then paste this into the box: >0000\-0000 When you click next it will ask you whether you want to store the data with the "-" between the numbers.

Try this: >0000\-0000;0;_ as an input mask.

I have a listbox on my form which shows a list of filenames that have been added from another listbox. The filenames can be quite long and contain commas in them. When the filenames are added, they split onto separate lines because of the commas. Is there a way around this?

thanks that sorted it!

I would like the following statement to take an entered value unless it is null. If there is no value entered, I would like to use the * operator to show everything from that field. IIf([Forms]![SearchForm]![txtinvestment] Is Null,Like "*",[Forms]![SearchForm]![txtinvestment]) Why does this...

I have tried that, but it still does the same thing. There must be some way to stop the enter key from moving focus to the next tab stop?

I am using the keypress event of a textbox to run some code instead of having to click a button. The problem I am getting is that when the enter key is pressed, the control simply moves to another text box. I believe that this has something to do with the Enter key behaviour event, but I have...

I have sorted that: =fGetProductVersion("\\PCNAME\c$\Program Files\Microsoft Office\Office10\excel.exe")

That work perfectly, but how would I use the same function to get the version number of a file on another PC on the network e.g. wks01?

That's great, thanks! Do I put this code in a module? How do get the values, call the function?

Is there any way to check the version number of a file from access? I am currently deploying Office XP Service Pack 2 across the network and need to check whether the updates have worked or not. The easiest way to do this is to check the version number of the excel.exe file. Doing this...

Speeding up queries: 1. Do not use select *, but instead select only the fields you require. 2. Use the WHERE function to limit the results of the query. Create or use a field that records the date that the record was created, you can then use this date in the query to select on the data...

:D I didn't realise anyone alse had it. Sorry!

No problem! I learn't Access from other peoples databases and code. The best way to learn is to write your own code for everything that access does, even if it will normally create the code for you.

That's the only way I could think of to make it work. You can't call the refdates function from the main form because it it part of the other form. You could maybe copy the refdates function to the main form and call it from there.

Yes that's right. It means that whenever you change the user from the Combo Box on the subform, then the Function refdates will run. This function shows the Calendar entries.

Open the Properties for the Combo Box on the subform and select Event Procedure in the after update event. Now when you select the employee from that combo box, the calendar will update.

I have sorted it now, thanks for your help guys. A value cannot be assigned to a bound control from the form's close event. I created a Complete time button and assigned the values from it's click event.

Open the properties for the Combo Box and go to the Events tab. Under the after update event, you have entered some code. Delete this and click on the button on the right hand side of the box (it has three dots on it). A box will appear asking you to select either where you want to put your...