Search results

I just want to go to a particular record in the form quickly in a listbox (I meant listbox rather than combobox)

I have a form based on a query with multiple primary keys. I have Company, MemberNumber and DateVisit as the 3 keys. I want to use a combo box to select a member and have been able to do it with the code below, which loops through every record to check whether the selected on exists and then...

Thanks! that DateDiff is brilliant for when dates are gratuitously converted to US format

I know this is a bit late, but for the sake of giving the info to anybody looking, I found the following code in the Access Help for changing the title: Sub ChangeTitle() Dim dbs As Database Dim obj As Object Const conPropNotFoundError = 3270 On Error GoTo ErrorHandler...

I actually discovered how to do it using the following bit of code: If rst1("RptPic") = True Then Me.Picture = "" Else Me.Picture = "C:\Program Files\Medical Insurance\vhi1.jpg" End If

I have reports which have jpeg backgrounds, which are standard forms (colored). I want to give the user the option of printing that background form, or , if he/she wants to put standard forms into the printer, print with no background (i.e. blank background). This would economise on ink if the...

Smeghead: I have used both the acErrDataAdded and the acDataErrContinue in my code but the combo is not requeried. Gemma/Dave: how do you suspend the processing in the main form or is it just a matter of having the called form modal? Where would you then requery the combo in the main. I have...

That worked fine, I just have to requery the combo box after returning from the add form.

I can see where this guy was coming from. Although the requery on the click event of the combo box does requery, this means that after adding a new record, you have to click on an existing record first before the new record appears in the combo box. One would hope to have the new record there...

DoctorCode is the unique primary key, but it isn't an autonumber. I will try your suggestions, Thanks

Here is the code in the Notinlist: Private Sub cmbGP_NotInList(NewData As String, Response As Integer) Dim Result Dim Msg As String Dim CR As String CR = Chr$(13) ' Exit this subroutine if the combo box was cleared. If NewData = "" Then Exit Sub ' Ask the user if he or she...

Thanks for your prompt response. At the moment the field I have for DoctorCode is not an Autonumber but a long integer. Do I have to change it to an autonumber for the code in the link to work?

I have a problem with adding new records to a combo box. Control source is usually a numeric code (primary key of table) usually not visible (col size 0.0cm) Name is usually visible because it is more user friendly. Adding new record: The user must key in numeric code which is the actual...

I know, should have put in the code. Apologies

Gemma was right. I had a command "stop" in the the end of a "Select Case ...End Select" sequence. I don't know why!, but it was highlighted in yellow, but compiled ok. When I removed it all was well. Thanks for all that. However, after all the compiling and de-compiling, my database is in...

Thanks for that datAdrenaline, but I still have the breakpoint, after going through that procedure. Also the compile is clean, Gemma_the_husky. I also don't think I compiled it with a breakpoint set.

I did just that and the breakpoint is still there.

I tried both of those without success!

Why would the debugger continue stop at a certain part of the VBA after I have taken away the break? Any ideas?

Actually I think I have sorted it out. When I package the db, I can package the image files, and they will be in the same program directory. I can point my link to this directory. The only trouble will be if somebody wants to install the db on any drive other than the C drive.