Search results for query: *

I would like to create many text boxes on a form. I would like to know if I could write code that would create text boxes based on numbers I have in a table. We have baseball players each has a number that reflects their age in this table. In this example of 7 year olds, Example: Joe Smith...

I have address data stored in Excel. Everytime we add a new customer, we add the address to this list. Is there a way to transfer this data to an Access table? And possibly weekly update to the same table. Or! each of our salesman have these addresses in Outlook. Could I do the same thing...

In this code It's not taking me to the new record. I see it add the data with the new number WIL-216. Then I start to edit the sheet and I find I am in record WIL-215. I can scroll and get to WIL-216, but sheet doesn't automatically go there? Any help would be great. Private Sub...

Is there any way I can do this code without putting the form in Dialog when it opens??? Everytime Im in Dialog mode my computer freezes (Any computer/ work,home, my laptop)?? Please any help? I can send the file if needed. Private Sub ProductID_NotInList(NewData As String, Response As...

I am writing code so that when I hit a certain button, the background turns to a very light purple. What color is very light purple? Or is there a chart or info on where I can find each color? Thank You, Michael

I can get all the way through adding a new product, then the data will not update in my combo button. Here is the code: Private Sub ProductID_NotInList(NewData As String, Response As Integer) If MsgBox("The Product " & NewData & " you entered, does not exist yet." & vbCrLf & vbCrLf & "Do...

I have a button I use to copy data to new form. It works great but I would like to add a number to a text field. Is this possible? IE: The sample number is WIL-215. I have the code below so far: How can I make the next SampleNumber WIL-216 automatically? Private Sub CopySample_Click()...

I have a Subform that I enter products. If the Product is not there it asks if you would like to add it. When yes is pressed, it opens a form called "AddProduct". You then add the product and close the form. It takes you back to the control you entered the product in originally. Then when...

I want to hide a button on my form when the record is new. How can I add this to my code of the button?? Here is the code now: Private Sub Command876_Click() DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend End Sub This copies data from...