Search results

Never mind, i figured it out.

Is it possible to set value of a field when form opens, based on a field from another form? For example, user opens a form that lists all companies, user selects a company for the job, user then clicks button that opens another form which is set to go to a new record, i would like the companyID...

Thanks for all your replies, however I still couldn't get it to work with the * idea. Colin you mention the Solutions db, how do i find that? I thought it was on my computer with the tradewind samples but when i did a search it didn't come up. I also did a search on this site for my question...

I have several reports and have built a form to select the report i need and then also select which county to run the report on. My combo box list each county and then "ALL" for all counties. My problem, the report does not know what to do when i select All from the combo box. The report is...

One more question, what is the easiest way to round up in my situation? For example .716 percent print out 71 and i need it to print out 72? Thanks in advance for your help

Thanks everyone that worked!:)

When i format it as a standard number it prints out as 0.56, percent prints out 56% i just want it to print 56. The column header lets the reader know it is a percent. Any other suggestions? Thanks

How do I get the % sign NOT to print when I have a calculated field, which is formatted as a percent? For example, I have a column header that says Percent and I have numbers in rows which print as 56% but I want to print 56, 10% should print out as 10. Any suggestions?

Thanks Pat for your suggestions, i want to try the first option but i am not sure what code to write to the double-click event. Can you explain how to do this? Thanks again

I build a form for user to put in a beginning record no. and ending record no. before previewing report. However now we need to not only select a range but also be able to add individual records for the same report. Example: i need to print a report that will include records 1-10 and also 14...

i have a query that works great until i put in simple criteria. when i put the criteria it prompts me with a "Enter Parameter Value" screen. The field with the criteria is a calculated field such as RemBal:[costs]-[payments]. When i put >0 for the criteria i get the prompts. When i take the...

Is there anyway when multiple users are sharing a form or printing a report that Access can make the user aware if someone is editing the record that they are LOOKING at? I understand record locking is to prevent more than one user from editing the same record, but what i am looking for is if a...

Thanks Fizzio, It worked great!!!!

What would be the best way to generate a reminder when a record have met a certain criteria? For example i have a db that has 1000 records. One field has DOB, i need a reminder to come up when a person has reached 18 years of age. I created a query that will give me that information but i...

I have custom navigation buttons on my form with a calculated field that counts the records. It works great except when I go to add a new record. The field that calculates the records doesn’t calculate correctly until after I exit the record and go back. I would like to figure out a way to get...

Thanks Pat, that worked, now for my next update query maybe you can be of help. I have two tables, one field i want to update. both are Number data type with Integer field size. when i try to run the update query, it gives me an error stating that it can not update because - due to a type...

I have an Excel spreadsheet that i want to put in Access and then break the data into tables. I had no problem importing the spreadsheet into one table, but when i try to put the data in different tables by appending records and fields i get a validation rules! the fields in both tables are...

How do i get this concatenated field to NOT leave a blank line if the Address2 field is empty? =[ClientName] & " " & [Clients.Address1] & " " & [Clients.Address2] & " " & [Clients.Town]:(

I have a report that needs a certain layout that is giving me problems. I need to put two addresses at the top side by side. The problem is that i have fields that i don't want shown when there is no data in the second address line. I have the "Can shrink" feature turned on and it will work...

Thanks Tim, it worked great!!!