Search results

I have been attempting to come up with a way to automate some administrative procedures. I have little experience with VBA, I can do the basics. I have searched this forum along with the internet in an attempt to find a example. Essentially, I have a table with a list of materials -...

Ahh, I figured it out. Thanks Bob you got my wheels turning! =[Company]+Nz(" By "+[EngineerArchitectCompany])

Thanks for your response Bob. As I understand trim is to remove leading or trailing spaces? I plugged it and didn't get the results I was hoping for. Any other ideas?

I have an unbound field that I have used the expression builder to populate and it needs minor tweaking. I just can't remember how :confused: The code currently reads as follows: =[Company]+ " " +Nz([EngineerCompany]) Instead of the blank spacing between them I would like it to read...

Thanks for your response CJ. If I am reading this correctly the code you supplied will change all labels on the form. How would I only change the header on the form, the name of the control I want to change is lblHeader? I would like the remaining labels on the form to stay set for Times Roman.

I am using the theme Newsprint in my database and the font keeps changing from Impact to Calibri on the one form and to Times New Roman on the other. When I switch each into design view the font reverts to Impact for the headers and switching to form view goes back to the alternate fonts :eek...

The form is sizeable and is not based on any tables. It contains about 15 command buttons all opening other forms and reports. All of the buttons it contains function without going through this process of resetting the form after redistributing. There are no other problems with the linking of...

I have split my database into a front end and a backend (access 2010). I am using a Navigation form with a button in the header that opens another form, a menu, that is loaded with buttons for reports and other tasks. Every time I update the front end and redistribute to the users the button...

Finally a solution! I exported my Hyperlinks into Excel from there used the function "Concatenate" inserting the #'s. Imported the new table back into my DB, turned the new fields Data Type back in to a Hyperlink. Like magic it works! Much easier then some other suggestions I was unsuccessful...

Perfect! Thanks for the guidance :)

ahh.. You're Wonderful! Thank you so much!

One side effect of the changes that were made - and I have ran into this before, but since you have been so helpful maybe you would know. On the form I have changed the control source to tblProjectEvents.JobStatus however now the form will only cycle through records that are present in that...

Another question, so I have the tables all set up like above. On my one form frmProposalDetails I have a button cmdAddtoWOH that opens a model dialog box - How do I pass what is the primary key JobNumber to the second form. Everything works as I would like it to I just want to prevent the...

So I'm with you thus far (I think)- so I should remove JobStatus or (fkEventID) from the tblProjects all together into this additional juction table. Then the other field ScheduledValue I was wanting I should insert into tblProjects and tie it back together with a query.

Thanks for you reply, my main reason for utilizing another table is for the utilization of the date stamp "now()". I have to know when it is approved because I may not be the one whom does it. Jobs should also be scheduled in order of approval, so sorting would be done by this field. To answer...

I just don't know where to really start to accomplish what I would like. I am using 2010 and am a beginner. I have a database that holds all client information and jobs (for service industry). Currently we use Excel to track "work on hand" which is work that has been approved. I would like to...

When I open the qry directly it display the message box "Enter Parameter Value" Forms!frmFolderLabels!txtWhatJob In the Criteria of the query it is set as: Like "*" & [Forms]![frmFolderLabels]![txtWhatJob] & "*" When I enter the job number it isolates that specific job with all the information...

Thanks for your reply, the error message would have been useful. It pops up as a run time error '-2147217904 (80040e10) and states No value given for one or more required parameters.

I am hoping someone can give me some insight into how I fix this code to fit my needs.:banghead: I found http://msdn.microsoft.com/en-us/library/office/aa140106(v=office.10).aspx?ppud=4 this article which explains how to make a dummy table and fill it with blank records. The author mentions...