Search results

I have it running off of a table. Should I have it running off a query instead?

I have it bound to an ID number, and it is set for single select.

I am having the opposite problem. I can't edit the values. I have the locked property set to 'no'. I can change which record is highlighted but I cannot change any of the data. And I have enabled set to 'yes'.

Good point. Ill get to that after I get what I have right now working correctly. Thanks a bunch!

Thanks, that works great! Any ideas on how to extract the city? I haven't started messing around with that part yet, Im not sure how complicated it will be.

Im trying to create and update query that will extract the state out of an address field, the address field containing "city state" (no comma). I have been messing with the instr, left, etc.. functions and I cannot seem to get it right. The closest I have gotten is using ...

Thanks.

Im trying to combine 3 databases into one. Everything works fine when imported in, such as the queries and reports. But none of my forms work. I get a Network connection lost error for some. And others my code behind my events is lost in the import. What am I doing wrong?

I tried vbcrlf, but that didnt work. I did get "Chr(13) & Chr(10)" to work. I didn't test it in the shared directory yet, though.

When I do that it outputs Name? I tried vbcrlf also.

Say my control for a textbox is : = "Title" & Date() How do I get it to show up on 2 lines, is there a 'next line' keyword? I want my output to look like this: Title Date (I know this would be really simple if I just made 2 separate boxes, lable and text, but my control is actually...

That works perfectly! Thank you sooo much! Of course its sooo simple. :D

Im not suppose to use forms. There is around 50 reports, and my boss doesnt want have a form attached to all of these. Which is quite annoying, cause a form would make is to much easier. I tried doing txtTownshipName.value = "test" which also didnt work, but I dont know if thats somewhat...

Ok, now I get an error at the line: txtTownship = strTownship its says 'you cannot assign a value to this object' ------------------------------- Leave it to me to make something simple rediculously complicated...

What do I put in the control source of the textbox?

Ok, I had something misspelled, but now it gets an error in the modules highlighting "test" where I have strTownship = "test" and it says "compile error, invalid outside procedure"

Ok, Im trying to do what you said Patrick but Im getting errors. I put this in a module: public strTownship as string strTownship = "test" then in an on open function i have: txtTownshipName = strTownship I get an error that says "procedure declaration does not match...

Can this also be done by defining the value of the global variable in a module instead of having a form for the reports? If so, How would the variable be defined in a report?

I have numerous reports that are used for different clients. At the top of each report is says the client's name. Everytime I run the reports for a new client I need to go into each report and change the name which takes about 2 hours. Is there a way to make some type of global change...

Thanks so much! The DateValue function worked perfectly. :D