Search results

You can easily do the name strings in your query behind your report. Let's say you have 2 different fields for your first and last name, this is how you do it in a query in a new column: Name:[FirstName]&" "&[LastName] Now, Name becomes your field and you can call it back to your report. You...

Have you tried putting all of your calculations in your query? If not try that and see what happens:)

No, I don't even have any macros. I did try importing everything to a new database, it does give me the same message, but this time when I try to open my form it says that my form does not exist. I don't know what is going on. Please help :confused:

I just worked so hard to make this form and subform. All of a sudden when I tried to open the form, it tells me this message "You canceled the previous operation" and the message keeps coming up. I can't even go the the design mode. My form and subforms are there I just can't open them...

I have a table where I have employee info and another table that is linked to employee table where it calculates their hourly wages. Regulartime, Overtime, and doubletime. Everything was fine until something came up and the company decided to pay a Per Diem(Per Day) to each employee. So in...

Thank you, I have done something similar to this too, but I guess my mind went blank today:o Thanks again :D

I have this calculated field in my subform for each employee. So, when each employee is chosen, it calculates a Per Diem for each day based on their hours of work. I did an if statement in my query behind my subform that works perfectly. I have a table where all this information is stored...

Can anyone help!

I need to open two reports at the same time. I have the code behind my button like this: DoCmd.OpenReport "report1", acPreview DoCmd.OpenReport "report2", acPreview But my problem is when report1 does not have any data, it deosn't let the other one open (I have the code behind the On No...

Then do this: =Sum(IIf([YourYes/NoField]= "Yes",1,0)) This will count your yeses.

Make a new query from your table and put this in the query: Date2: [Date1]+17 :)

Make your report thruogh the wizard. The wizard will ask you if you want to group your data and that is what you actually want to do. For counting the yes fields, just go to search and you will find lots of info there.

Go to File/Page Setup and choose the tab columns. You can set your report to have as many columns as you want. :)

Refer to this posting: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=24516&highlight=crosstab

Your report is not maximizing when your are opening it. Try to put the docmd.Maximize in the onopen event of your report, so when you close your report your form will still be maximized :)

I want to make this as easy as possible for the user. When they click the button it just prints and does everything that I want in the background, with no questions to ask. I thought there are other ways of doing this without running an update query. I was thinking of putting some kind of...

Thank you for your reply Pat. I know that I needed to make another table out of my fields and did not normalize, but I had my reasons for doing this! These fields will not change at all or be added to. I run very complecated reports and by doing it like this my reports work perfectly. I...

Hello everybody, This should be very easy for you. I am planning to send post cards to customers to notify them for their move. I made the post card and it works so far. I have a date field in my table for when every time there is a card that is printed would put today's date that this card...

Hi everybody, I have about 28 fields that I have on a report. These fields are dollar amounts that the user puts in. On my report I want to show only 95% of the amount they input not the 100%. for example if the user puts in $405, in my report I want it to show $384.75 which is 95% of $405...

Click on new for reports and choose Lable Wizard. The wizard will take you through and you can make your data lable! :)