Search results

I have a db where I import building reports on a daily basis. The initial report has numerous fields that are filled in the first time the report is downloaded into my db. The firm I get the reports from has the same Main ID#, i.e. 201400567891 that remains the same, but the Version number...

Finally got back to addressing this issue and your suggestion to look at the order by property did the trick! Thank you very much! :D

Thank you for your answer Paul. As I mentioned, I have never used VBC, so where would I put the Text string above in the following routine? Private Sub Open_Job_Process_Call_Report_ASI_Group_Click() On Error GoTo Err_Open_Job_Process_Call_Report_ASI_Group_Click stDocName = "Job...

I successfully set up a query that will pull the information I want. I have developed a report that when I open it manually works perfectly. [Job Process Call Report ASI Group] The issue is that when I try to make a command button to open up]Job Process Call Report ASI Group] I get a compile...

thank you for your kind offer, however this is a HUGE db and it would take me forever to strip the date down to a point where I could attach the file. :(

I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see...

Thanks, Paul! Actually, I took a break and it finally came to me....all I had to do was put =" " in the criteria field and I got the results I wanted. I knew it had a simple answer! lol :D

I have searched the Query forum for quite awhile and can't seem to find an answer to this question, even though it seems pretty easy, I can't figure a way to do it.:banghead: I am just querying a single table, no relationship involved with another table. As you can see form the attached...

Thank you for the suggestion, however, when I run the query with this statement iif(Len(zip) = 12,Mid([ZIP],2,InStr(1,[ZIP],"-")-2),Mid(zip,2,5)) the result is every ZIP field is update to "ip" for some reason, as per attached (.jpg)

Still getting the same result. Please look at the (2) .jpg's I attached, the original and Step 2. As you can see when I enter your suggested command Mid([ZIP],2,InStr(1,[ZIP],"-")-2) in the Update Field of the query, the result of the query is perfect IF the original zipcode was...

I thought I had solved my initial problem of removing the apostrophe character for each zip code field. Most of the fields have data that reads '12345-1234'. I want to remove each (') character and the "-1234" so I end up with a zipcode of 12345. I created 2 queries for this process. I first...

I appreciate the advice, Simon. I will keep that in mind..... :)

Worked like a charm! thank you very much :)

Still new to this game.....where do I make this change? In the query itself? thanks for the help....Mark

Is there anyway to enable a query that pulls up just the basic information from a table and then click on the primary key field to open up a form I have created that contains all the information in a table in a more user friendly form that I created. The two images attached show the data...

I have some queries that pull data from one table and other queries that pull data from two related tables. In both cases, how do I prevent the data from being changed after the queries results are displayed? I know I could make a form and lock each field so it couldn't be changed, but I was...

Thanks for the idea! It seems to have worked perfectly! :D

I am trying to copy notes from one table to another table where a condition has to be met and I can't figure out how to do that in an APPEND query.:banghead: Each record has a unique number that comes into my Initial Table in my Access database from a construction program I download. In...

I have a subform which tracks all the notes our personnel have entered in a specific project (which is the main form). The issue is that I want the most current note to show in the subform when the project is "opened up". The underlying query for the subform has the [DATE] field sorted on...

Thank you for this info! Just one question, since the field currently has 10 characters in it, i.e. 2014123456, and there are 6 characters after the original 2014 should the formula be: Left([field],4) & "00" & Mid([field],6) Just want to make sure I get this right this time! :) Thank you...