Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. basco81

    Invalid use of Null????

    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!!!
  2. basco81

    Invalid use of Null????

    Anyone have any suggestions??
  3. basco81

    Invalid use of Null????

    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...
  4. basco81

    Invalid use of Null????

    nope...still doesn't work...thanks for the help though
  5. basco81

    Invalid use of Null????

    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...
  6. basco81

    Invalid use of Null????

    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"...
  7. basco81

    Enduser being able to change title of form

    Thank you both...you guys have both been very helpful, I really appreciate it.!!!
  8. basco81

    Enduser being able to change title of form

    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
  9. basco81

    Enduser being able to change title of form

    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...
  10. basco81

    Enduser being able to change title of form

    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.
  11. basco81

    Enduser being able to change title of form

    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???
  12. basco81

    Enduser being able to change title of form

    Sweet the form is working great now. Just one other question. How do I get the labels on my report to change to this also???
  13. basco81

    Enduser being able to change title of form

    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.
  14. basco81

    Enduser being able to change title of form

    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...
  15. basco81

    Access newbie help with linking Multiple tables to one form

    Thank You so much...It is working like a charm now. Didn't even think a/b using that intill you reminded me.
  16. basco81

    Access newbie help with linking Multiple tables to one form

    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!!...
  17. basco81

    Access newbie help with linking Multiple tables to one form

    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...

Part and Inventory Search

Back
Top