Search results

Thanks very much for your help. I will check out the articles. KerryDee

Thank you very much Steve for your prompt response and taking the time to help. Whenever a user choose either Replacement or Correction combo box, either Replacement or Correction fields in the combo box will be generated in a report, not both. The report can only have either Replacement or...

Hi I appreciate any help I could receive for my problem in the attached DB: Form---The Report shows Replacement and Correction Combo Boxes. The user can only choose either a Replacement or Correction field. I received the code for the user to choose either combo box from Access World, as...

I placed the code in the After Update in the properties instead of the Change property.

Thanks guys again I was able to get it to work by placing the codes in the After Event in the property field.

Thanks to all for your input and I will try all suggestions. I am sorry for not responding sooner. To answer missinglinq's question. I am trying to accomplish exactly what mjdemaris points out. For example, typing in the combox, Ker and the combox completes the rest if Kerry exists. 10,000...

Hi I was able to receive valuable help with VBA codes on the attached DB. Can anyone help me figure out how to enable the Combo Box to Auto Expand the Comb Box when typing in the field? Thank you very much!!! KerryDee

Hi I will like to know how to create a FindRecord macro to search by FirstName, LastName, LineItemCode and Address. I have already created a ribbon, but I will like to add <control idMso="FindDialog" size ="large" label="Find Records" enabled ="true"/> to add a macro that will search...

Thanks MarkK and Beetle for your help. It works perfectly. I am also going to start a new thread on figuring out how to attach VBA to a Ribbon. Thanks again for your tremendous help.

Thank you very much. I am a novice at VBA what but exactly should the line code say? I got this code off the internet. Thanks again.

Hi the error does not give me a number, it says the following: Compile error: Variable not defined Thank you.

Hi I am getting a Compile Error with the following code with the highlight strsearch = The code is below: Option Compare Database Option Explicit Private Sub btnSearchCarlsbad_Click() Dim strString As String Dim strText As String strText = Me.txtSearch.Value strsearch = "Select* from...

Thank you very much. One of the downloads was exactly what I was looking for.

Hi: I built a ribbon to open Forms, and Reports, but I seem not to be able to Close my Form because I do not know the rest of the code to Close a Form: I have the following so far to show the Ribbon Image MergeViewClose (which display the X image in Access), but I know I am missing...

Thanks, worked great!!!!

Sorry, I mean if it this is a new record to preview a single record before printing. Thank, KerryDee

Thank you very much. You are correct!!! By chance do you know how to tweak the code so that I can preview the current form information (for a single record)? Thank you very much.

Hi hoping for some help on a button I am getting errors on. I want to preview my form in Access but I am getting a "Syntax error (missing operator in query expression id=". Here is the code I am using: Any help will be greatly appreciated. Thanks very much: Private Sub...

Thank you so much, it's exactly what I needed!!!!!! Thank you. Thank you. Thank you!!!

Thanks for asking, but the information on the Access form I uploaded is for a form (which is built in a report in Access), that is required by a state agency. It allows a user to choose either a Correction or Replacement but not both. Thanks, KerryDee