WOW...thanks guys, never knew it would be that easy, I have checked and rechecked code for hours, but it is always the simple things I forget, THANKS!!!
Hey,
Sorry it has been a few days since I have been able to work in access. I have figured out why everything is not working just having a lil' troble fixing it. The data doesn't seem to be storing into my table, I have checked my code and can't seem to find any errors. Please browse over the...
Thanks for the Info, but still having a small problem. The lines of code I have originally are accessing the table and then adding that info to the labels. I also have another set of code that allows you to change the labels and stores the data into tblparameters that way when you restart the...
Private Sub Form_Load()
Dim l_title As String
Dim l_title1 As String
Dim l_title2 As String
Dim l_title3 As String
**l_title = DLookup("Customer", "tblParameters")**
l_title1 = DLookup("Project", "tblParameters")
l_title2 = DLookup("Location"...
Ok guys, think i am getting very close. I am attemting to use this statement to store the data into the table, is it correct??
DLookup("Customer", "tblParameters") = l_title
because it is giving me the error "object required
Ok...still having troble with the file stuff. But then i also just realized that in order to use the file way I would also have to make the files dynamic correct???...because this way it would only work on my machine. If I created a parameters table as PH suggested how would I get the string...
First off lemme say, thank you so much for helping me with this...i really appreciate it. Second I having troble with the code because it keeps giving me an error saying "file already open" after the first time it opens in the code.
Also...Is there a way to make it to where the enduser doesn't have to reenter the data everytime he/she opens the form. Ex. to have the value in the caption box of the label properties actually change???
Ok, I think I see what you are doing, but what does the 1_title = inputbox "Please enter new Title" do? I tried it and I am getting a syntax error, I believe that it should make a box pop up to enter the new data in, but can't get it to work.
I am attempting to create a form in which the enduser will be able to click a command button and change the title of the form. The title of the form is made up of 4 Label boxes(will change to text if needed).
(Customer)
(Project)
(Location)
(Type of Form)
When the command button is clicked I...
Just to let you guys know, I am trying the format of =[tblLabels]![Customer] in the text box to attemt to link it in the new table but can't seem to get it to work. Is there something wrong with my syntax??
Please help!!...
In a database I am creating, the client wishes to be able to change the title of the form and report by clicking a control button on the form. I have it set up so far that when they click this button another form pops up and allows them to enter the info into a set of text boxes, which are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.