Search results

It gets even odder When I right click on the table in design view and open the properties and select the Id field to order on and save, everthing is fine in datasheet view, as one would expect. The minute I add an autonumber field the Order By in the properties becomes null, i.e. the field...

Table containing ID field on following format: GEF001 GEF002 . . . GEF800 I'm wanting to add a new autonumber field to the table but want the table to be ordered by the existing ID field before adding this new field. Right clicking on the field in Datasheet view, order the ID field in...

Thanks Paul, Dmax seems to work well for finding the max record in my ID field, e.g. ID GEF005 GEF312 GEF807 Unbound box on form containing following Control Source code: =Dmax("ID","MasterTable") gives: GEF807 However, when I add +1 to the end: =Dmax("ID",MasterTable")+1 I get #Error in...

Thanks Paul. Have just realised I'm unable to change an existing field to an Autonumber field. Is there perhaps any way of doing this? Perhaps adding some code to update the field automatically or the likes? Thanks.

Essentially two related question, a workaround for either would be appreciated. Trying to format an autonumber field: "GEF"#### e.g. GEF0015, GEF1258, etc Alternatively is there anyway around finding the max of a field of the format "GEF"#? The issue is that when I run a query to find the...

Similar Issue Just had a similar issue after trying to alter some code in the master form. Had a look at the size of the corrupt DB and it had shrunk from ~74MB to 456KB :eek: Luckily I have backup copies of the DB.

Yip! Makes sense, If Dir(ProjPath) = "" Then works great, same as the Len option.

Odd! Interestingly enough If Len(Dir(ProjPath))=0 Then seems to work fine, file not found message pops up no problem With If Dir(ProjPath) <> "" I still get nothing happening when I press the button in the case where the folder exists but the file doesn't. Thanks again to both you guys...

Thanks Fellas All starting to make sense. I'll give If Dir(ProjPath) <> "" Then a go when I get back to work next week and let you know if iw works. The rest of the code is accurate btw. I'm assuming I could also use: If Len(Dir(ProjPath))=0 Then ?? Thanks heaps, much appreciated.

Macro - SetValue If you're wanting to do this in a macro you should look at the SetValue action when you create a Macro, this should cover what you're after. You should also be able to append the domain on the end by concatenating the pasted text and "@domain.com". There are two Arguments to...

Oops - Correction Was trying to make things a little simpler, which may just have confussed things. "Name" is actually "WellName" which makes Me.Name.Value actually Me.WellName.Value, if that makes sense. Sorry for any confussion.

Hi, Posted a short thread the other day with regards picking up an error message if the file length was null. I've managed to get halfway there but am still having some issues and was hoping someone could help. Here's the code I'm runing off a button in a form: Private Sub ViewLogImage_Click()...

Have the following bit of code which opens an Excel file related to an entry in a form when the user clicks a button: Private Sub Cmd_OpenExcel_CoreLoc_Click() Dim CorePath CorePath = "W:\Core Data\" & Me.WELLNAME.Value & ".xls" Shell "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE...

Luck at last Thanks Ken, I was trying to run the requery in the after update event of the control, which wasn't working. I've since added it to the form after update event and added a save button. Thanks a lot.

One form two search combo boxes created with the wizard which finds a record on the form based on the value selected in the combo box. Combo box works a treat. However, when I add a new record the combo box list does not update with the new record. It does if I close the form or put it in...

Excellent Brilliant, got it to work, thanks heaps.

Hmm, thought I tried this earlier but it didn't work :confused: I'll have another go at it in the morning.

Thanks again Mailman, Taking your example: ?Dir("C:\Win*", vbDirectory) Could one use a field value on a given form in place of the Win? e.g. ?Dir("C:\Me.Windows.value*", vbDirectory) Perhaps a silly question but why is there a ? in front of Dir? Apologies for lack of knowledge, I'm VERY...

Thanks Mailman, Would someone mind giving a simple example? I'm not having any luck, Explorer is opening but only as far as the root directory. An example of the basic setup: PR_NO field contains PR numbers: PR 0678 PR 1289 PR 3465, etc, etc The "root" folder address is G:\MED Data\...

Have created a bit of code so when a user clicks on a button it open Explorer in the correct folder location, here's my code: Private Sub Cmd_OpenExp_MEDLoc_Click() Dim ProjPath ProjPath = "G:\MED Data\" & Me.MED_FolderLink.Value Shell "C:\WINDOWS\explorer.exe """ & ProjPath & ""...