Search results

From another forum, it was suggested that I only use SELECT DISTINCT qryPurchaseInfoNew.TracModel. When I do that, nothing appears in the combo box. If I remove ID from the Select Statement, then all i see is the Brand (John Deere) repeated upto 30 times. Which is from "qryPurchaseInfoNew.Make"...

Some of the models say 6230, will show three times. I want the combo boxt show 6230 only one time.

I am reworking a DB to simplify maintenance for salesman if/when I leave this company. The intent is to consolidate three tables into one flat file (which will work just fine). However, I still need to be able use three cascading combo boxes to filter the search. My first combo box (cboBrand)...

I have decided to re-make a table and at the same time, remake the form. On the form, I will have three fields that will effectively help drill down to get the right data. Brand (John Deere, Kubota, etc.) Model (there are 20 different models in JD alone, as well as other brands) Model Desc...

what would happen if I made a copy of the FE for each user on the network so the effect is each user is running their own copy.

I have a database that we have been using for about three years. The DB consists of a front-end and a back-end. I have about 30 users that share the front end using a shortcut. (Again, this has worked like a charm for three years). Each user has Acess Runtime installed on their computer. Just...

scroll up the thread and find my Jan 16 post: Look for "Public Sub Form_Current()" Its all the lines between that and ends and the first "End Sub"

I have a form that is used I to display tractor purchase price information. To get to the particular tractor I want to look at, I have three combo boxes that help me find the tractor I want. The first box "Brand", displays a list of different tractor brands The second box "Model", displays the...

I got my problem solved. After searching other resources someone mentioned calling the sub routine that performed the desired action and then repaint. so the resulting code in AfterUpdate was: Call Function_Current() Me.Repaint Voila! the text boxes I needed to change colors, changed colors...

here is my Sub Form programming where fields are checked and colors changed in the fields I use when the new record is displayed the last four lines are the AfterUPdate for the specific combo field. +++++++++++++++++++++++++++++++++ Private Sub Form_AfterUpdate() Me.Repaint End Sub...

I have tried the "Me....." suggestions and nothing seems to work. Perhaps this tidbit will help. If I make the change to the field, change to a new record and then back to the record I change, the fields have the new backgroun colors I need. I even put the If Then lines that are in the...

I have been putting this in OnChange

I used me.Recalc and the screen did not refresh.

I have a combo field that, when changed will update the background color on itself and two other fields. The issue is that the colors dont change until I have gone to another record and then come back to the record I am working with. While this generally works, I would rather have the screen...

I have a split DB that I want need to copy and use in a different manner. The new use will be putting a version of the DB on indvidual laptops (sales) so they can use a price tool program. This will require copying the current FE and BE DB's to a new name - "blahblah-be - Sales" and "blahblah...

Just to give a final update, below is the code I found on this site from a post dated a few years ago. I placed the code in one of the modules loaded upon startup. Public Function getWinUser() As String getWinUser = Environ("UserName") End Function In the CreateBy field in my form, I put...

This thread is old, but it solved my problem! Thank you

Ted.Martin Can you share how you are getting the Environ variable to work?

so, what am I doing wrong? As I said, I have tried it numerous times with no luck Just to reiterate, I am using an unbound text box and under "control source" i have entered =environ("UserName") (I have actually tried all sorts of variations of environ (with leading "=" and without) This is...

I have stored the LoginID into the table that is the basis for the login form and the name is still there even though the login form has closed. I made the Default Value of the Textbox =[Imagepath]![LoginID]. when I open the form, I get #Name? error. Suggestions?