Search results

Great tips Bob. I never thought about setting the form to data entry. The save button code is actually the code the wizard builds into it. I'm still a beginner with VBA, so I think I would have probably used your example if I coded it myself due to it being shorter. Thanks again for the pointers.

I made this real quick mostly with the wizards. See if this can start you off.

Try this. I created a combo lookup through the combo box wizard to search for the records instead of the way you were using it. I put the combo box on the upper right side of the form. I think this is what you were looking for.

Go into the design view of the form. Go into the properties of the form by right clicking the upper left hand box. Scroll down until you see the "on open" property. use the drop down and choose "Event Procedure" click the 3 dot button next to the event procedure. This takes you into VBA You will...

If you put that code in the on open event, it should automatically do it everytime it opens. Maybe put it in the On load event as well.

Is the text going blue when one of your conditions is not met. If that is the case and you want your defult text to be black, put the following before End IF: Else Me.Minimum_Stock.ForeColor = vbBlack End IF This will make the text black if it does not meet any of your above rules.

Try putting some code in the on current event on your form like this: Private Sub Form_Current() If Me.colour = "Red" Then Me.othertextbox.ForeColor = vbRed ElseIf Me.colour = "Green" Then Me.othertextbox.ForeColor = vbGreen ElseIf Me.colour = "Blue" Then Me.othertextbox.ForeColor = vbBlue...

Try a union query. Here's a link that shows you how: http://custom-software.biz/AccessWizard/Mar06.htm Let me know if you have a problem with it. it worked for me. Here's a quick rundown: -Create a new query in design view -Cancel the show table wizard -click on SQL view -Enter your syntax...

Do you want the cursor to be in a field and not be highlighted, or do you want no curser in any fields? If you want the curser to still be in the same field, you can try a sendkeys on the on open event. This worked for me: SendKeys "{F2}" It's not pretty, but it worked for me.

It could have also been that the Windows theme was different on both computers which is found in the display properties->Appearance->Windows and buttons. I had that same problems and didn't figure it out until after i switched to the same stle monitor as my client.I was using windows xp style...

Format([PERMIT]![PER_DATE],"mmddyy")

Good call Doc. I'll have to call our IT guys. They lock our PC's down. Thanks for the info....Gregg

I believe I have the same problem that you are having. For some reason I can't use jpegs of giffs. Bitmaps seem to be the ony thing that will import into my databases. I'm not sure if thats a setting or something, but I just use mspaint to convert my images to bmp format.

Worked like a charm. Thanks for the quick reply and great information. Gregg

I am using the folling code in a after update combobox event: Dim rst As DAO.Recordset Dim sqlwhere As String sqlwhere = " " If IsNull(Me.comboSearchSerial) = False Then sqlwhere = "SerialNumber='" & Me.comboSearchSerial & "' and " End If mysql = "SELECT TBL_RMA.* from [TBL_RMA] Where "...

You copied the combo box, but you didn't copy the the code that was in the after update event. Try this.

One way I got around it was to right click on each field in dataview and click on "Freeze Columns". This will not let the fields be moved, or widened. Then I disabled the ability to use the right click feature so the user is unable to unfreeze the fields. To do this, go to Tools - Startup and...

I'm not sure if this is the same problem, but it sounds similar to something I ran into. On my machines at work, our IS separtment Imaged the machines and every office program started as if it needed to reinstall the program. We were able to fix the issue by pointing the program to the office...

Go to File - Get External Data. Chose to either link or import. When the file dialog box appears, change the dropdown from Microsoft Access to Microsoft Excel and select your file.

Thanks Paul for the tip. I tried the got focus as well, but I'm not that crazy about the drop down being open every time i go to this page.I like to assume that they are using this field a majority of time,so when the database opens, the focus is automatically set to the search field. It's a...