Search results

It’s now on my “to read” list. Again thanks.

Thank you Minty, that is exactly what I’m looking for. Much appreciated 😊

Could anybody tell me if it is possible to set gotfocus on form loading, what I am trying to achieve is to change colour of each field when selecting. I can do this on individual fields but would like to set this parameters for all field service on loading the form. Thanks guys.

I have another issue before i make an changes as you suggest, I get this error: Do you know why I get this? Thanks again theDBGuy.

Thank You TheDBGuy, couldn't see that for looking.! Is there a way to get the part number to auto populate the "Part No." field when the New Part form opens?

Would it be possible for somebody to point in the right direction with an issue I have with Not In The List option on a Combo box. I have a form for ordering parts with a sub form within for selecting the part, What I am trying to achieve is input a new part number into the Combo box which...

Thank You!!! it worked. Thanks DBguy, Much appreciated, I can sleep tonight. Really great to be able to call on you guys for help. Again, thanks.

This is what I have DoCmd.BrowseTo acForm, "frmDeliveryNote", "", "[Forms]![frmDeliveryNote]![DeliveryNoteID]= [forms]![DNote]![Text1]", "", 1

Tried this but couldn't get it to work!

Hi Gasman, is this what you mean DoCmd.OpenForm "frmDeliveryNote", , , "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]"

Hi Guys, I'm trying to open a form to a specific record, I have a navigation form with a button and text box where i can input the specific record number, although the form opens, it always opens to a new record, I'm using the following to open the form. DoCmd.OpenForm "frmDeliveryNote"...

Thanks Guys, all sorted with the Combo solution. Again great help from you guys!

Thanks Uncle Gizmo for your reply, I do not have an issue with the Form Combo box returning the correct text, it is when I try to print a report that I get the issue of just the ID returning in the customer field. Shouldn't the customer field in the report return the text shown in the combo box...

Hi CJ_London, yes I have set these as above.

Hi ZeroAccess, My report is based on a query which pulls all the correct data from the form and sub-form with the exception of the customer name, which is the combo box selection, this returns the ID in the field. Could you expand on your solution of converting the table based recordsource as...

Thanks guys for your replies, I haven’t had a chance to try an god them yet, Hoping to get round to it later today. I’ll post back the results. Again, thanks all for taking the time to get me out of a hole!

Been struggling with this for a few hours, I have a form with a Combo box to select customer details, which works fine, however,, when I print a report the Combo box selection shows the record ID and not the Customer name (which is the combo box selection), can anyone help stop me pulling more...

Sorry The_Doc_Man, I probably didn't explain very well. The cells emailed rom the engineers always come in the same format (they select the cells from a standard spreadsheet) and consists of 8 cells, all formatted as Text. We are only at the receiving end.

Thanks, I’ll have a look at this later.

Hi, the ultimate aim is just to get the emailed excel cells into my Access table in the simplest way possible for the end user. Does this clarify the process.?