Search results

Close Form It's in the code. Me.Close AcForm closes the form and just that. It doesn't close the Db which is why the lock file is still there. If you want to close the Db then DoCmd.Quit

Time Issues Just beware if the Form is very long and has a large number of images then the Form will have to get them all and this can take time especially as you seem to be using a Network path K:\ You could put in the header a button to display the images or not.

OnCurrent Event You need to set the image in the OnCurrent Event Brian

Switch on the Combo You could switch the object visible when the user changes the combo setting. If Estimate the set Me.EstDate.Visible =True and Me.ActDate.Visible = False with the combo box OnChange and setting Actual then Me.EstDate.Visible =False and Me.ActDate.Visible = True You end up...

Hi All, I have lookup table "TblLu_Consultants" which has two fields ConsultantID AutoNumber Consultant Text The table is used in two ways, one to store the ID number in another table as a lookup on a Form and the second to store the Consultant Name in the table. They are both used in several...

Thanks, There were no differences but apparently there is a known issue. Just tick another reference close the Db, open and then un-tick the new reference. It works fine after that. Bizzare but fixed.

I have an application with some queries which have syntax like the following examples Left(fieldname,3) AND Right(fieldname,3) AND UCase(fieldname) AND Mid(fieldname),4,3) The code works perfectly here but when translated to the swedish version it does not like the functions. Does anyone know...

I have written the code with help from Microsoft to add contacts to the Oultook Contacts folder from me Acces Db and can also update existing records, but there appear to be some fields which are blocked, such as FirstName and LastName. Does anyone have some nice code to update the Outlook...

Due Dates Not quite sure what you mean, but if you just want a report with the current records data and also the 12 due dates then you could add a text fields with the data =DateAdd("m", 1, CDate(StartDate)) then another with data =DateAdd("m", 2, CDate(StartDate)) etc. etc

Mail Merge Problem This is really more of a mail Merge issue. This is from MS Office help and works perfectly. If you look at the merge field and then edit the code there, by right clicking on the FIELD and selecting to edit the switch. =========== Specifies the display of a date or time. This...

Thanks Thanks for the reply. I was hoping for something like Delete Line (1) but the more research I've done I think yours is the best (and only) option. For your amusement this is what I have ended up with. Not pretty but it works. Private Sub Command5_Click() Path = InputBox("Where is the...

I have a text file created by some other software which I cannot get access into but I can import the text file (from the path) to Access with a very somple piece of code: Path = InputBox("Where is the file?") DoCmd.TransferText acImportDelim, , "TableRecords", Path, True This recognises the...

Update ImagePath You could try to add to the AfterUpdate and OnChange Events of the ID control the code If notNull(Me.ID) then Me.ImagePath = Me.ID &".jpg" End if Or better to create a sub and call it from those events.

Update ImagePath You could try to add to the AfterUpdate and OnChange Events of the ID control the code If notNull(Me.ID) then Me.ImagePath = Me.ID &".jpg" End if Or better to create a sub and call it from those events.

I have a Form with a single Text Box, into which is filled a filtered recordset (ClientLST). The idea was to then allow the user to select specific Clients to add to another table. This all works but we now need to produce a report containing the ClientLST recordset. The system takes about 30...

Workgroup files This is the basis of starting an Access application with a specific workgroup file. The user can use the default workgroup information file or can force Access to use a secured workgroup information file created for a specific database. To associate specific secured database...

SQL Code Change to strSQL = "SELECT " & str_choice & ".* FROM " & str_choice & " ORDER BY " & str_choice & ".FIPS;" This should work but you may have to add in ," & str_choice & ".FIPS to the select side.

Visible Word Document Try adding WordObj.visible = true straight after the open line e.g. WordObj.Documents.Open StrOpenFile WordObj.visible = true Brian

Adding Users from a Form Any ideas out there? :confused:

I am trying to add new users using code so that the internal Access tables match my own Users table (tblUsers). I use the tblUsers to hold Job Title, Fullname, Tel no etc and use this in reports and merges. The code I use is... Set adoUser = New ADOX.User adoUser.Name = sUserID...