Search results

This should be obvious. I’m overlooking something? The database I submitted only has the following: 1. Table: “Salespersons” 2. Form: “SelectSalespersons” 3. Query: “SelectSalespersonsQuery” Building off information I found of this site I should be able to open the form (item 2 above) and...

What i'm searching for now is how to do away with the indiviual tables in the access database and link to tables in our sql database. Tables that have already been created in great plains. This eliminates having to update more than 1 set of tables and the SQL tables are already updated (new...

I need some expertise on a project I’m working on. In the stripped down version of the attached database there is an order form, customer table, order table and an order query The only fields on the form are the top combo box (company) below that is another combo box (customer/contact) below the...

This is what I'm trying to do: I have a table(customers)with the following fields: CustID,CustomerName,Address,City,State,Zip. Currently, I have a form with a combobox(Customer)which is tied to the table CustomerName field, selecting a customer from the combobox dropdown list fills in 4...

I have a form with a combobox (Customer) that controls info in 3 text boxes (address, city ect) I added another combobox (company) above the first and want this to control the same textboxes all info is in same (table) and same source row (query). I would like: If user picks company it pulls...

I have an AutoNumber field on a form. Prior to an AutoNumber being generated the word "(AutoNumber)" is displayed in the field - is there any way to hide this. Thanks Vince

I have a database that when the form is opened it is blank (new record). On this form ia a command button (utilities) which opens another dialog form that has 3 command buttons to perform various queries – it also has another command button (find record) which, when clicked would display a...

This dosen't seen logical but it might be possible so I'll ask ......... I have a command button (exit) on the main form which closes the form ----is it possible to have that same cb also close the access window -----so the user is left at the desttop of their computer? Vince

I've read that you should use the "Option Explicit" on almost every Function or sub to eliminate undefined variables. I wrote the code below before I added "Option Explicit" and it worked. Now, using "Option Explicit" - I get an error: "Variable not defined" ProductName = Cleared...

I have a new record button that runs the code below: Function NewRecord() DoCmd.GoToRecord , , acNewRec End Function I also have the code below associated with the main form (so it will not update unless all required fields are filled) Private Sub Form_BeforeUpdate(Cancel As Integer) '...

Below is an simple example of vb associated with a command button (Print) Option Compare Database Private Sub PrintRecord_Click() On Error GoTo Err_PrintRecord_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection Exit_PrintRecord_Click: Exit...

The “Call” procedure is new to me – I’m not sure how to use it – what’s wrong with the following? I have the following in a module: Function NewRecord() DoCmd.GoToRecord , , acNewRec End Function ************************************************* And the following in the OnClose...

What I have is this: Macro from a database window (design view) I used GoToControl (field) RunCommand (Delete) for each field in the form, if certain criteria is not met (thereby eliminating the creation of another autonumber record) Is there a single action command that will delete all...

What action argument would I use to clear all fields in an active form? I created a toolbar named "new record" upon clicking - I want this to run a macro that if all required fields are not filled it will clear all fields in the active form. As it stands now, it moves to a new record and the...

In the designview of a macro from the database window - I have several GoToControls that display mesage boxes if controls are null - the last control in the series is on a subform and the messagebox works fine but the focus will not move to the control on the subform - I tried several actions...

I put a new command button on a customer form, the form is set to auto center. This Find Record command button when clicked opens up a find and/or replace dialog box. It opens on top of and obscures the customer form. Is there something I can do to force this built-in find and/or replace window...

Is it possible to color specific words (characters) in a message box text? Not the entire message just part of it. Thanks Vince

I stole the following macro from Microsofts’ “NorthWind” Database - adapted it slightly for my form. I cannot get it to function? Similar to how it functions in NorthWind, If a Branch ID is not selected prior to a product on the subform - I would like it to display an error message and upon...

Concerning check box behavior... I got the (label) color formatting fixed thanks to Senior Members input. Now here is another question.......... When I first open a form that has a check box - the back color of the check box is grayish or a fine pixel appearance when I check it (click) it...

Is it possible to conditional format a check box or the check box label (it appears the label is what actually gets the focus and not the check box itself) the standard way for text boxes won't work. I want the check box (label) to stand out when it has the focus so it draws the users attention...