Search results

I uploaded your database with the changes and renamed the database (want to use it for a class). Couple of things that I noticed: Don't put anything in the page header or footer if you are using it as a sub report, it usually won't show up. Use the report header or footer instead. Right...

Can you put the picture in a report, then export the report to a word file?

Assuming all your transfer ID's are sequential, I've uploaded a solution. Follow the steps in order qrystep1..., qrystep2... etc. Make sure you understand what each are doing.

Instead of writing long if statements I set up a cross reference table which can easily be changed by an end user if necessary. I've uploaded a sample, look at qryFinal and the column Final If Statement which has your answer.

Here's a sample for you. Chose a value in each of the drop down boxes, then click the button to get results.

copy and then right click, paste formatting instead of regular paste.

Instead of using vba code, I created a cross reference table. Created a query with it and your table. I had to convert B to a number using Val([b]). Then created some if statements. The query I created is called qryGeof and the result you want is called FinalResult. Hope I understood it...

Convert the number to a string using the str function. IDasString: Str([ID]) - id was my number field and I chose to call it IDasString. I've added a picture to show you that it works.

I just noticed another thing. You have JSA Record - Page 2 Report - Page 1.jpg set up as a sub report. So in the end you really have two reports that each have sub reports. I'm not sure if you really need to set it up that way. Can you move just the reports to a database and upload it...

In the last picture shink both reports in the detail section so the are thin lines. Make sure you set them to can grow. Let me know if that works.

This website uses in instead of like. Haven't tested it yet but should work. http://www.fontstuff.com/access/acctut06.htm

You have to make the form detail shorter. Design view the form grab the form footer and move it up.

Is actually creating the record? Access will show another record available to enter data and your defaults will show in that record , but until you click into it or add data, it's not really there. To be sure enter a record then look in the table, do you have one or two new records?

I understand now. Let me think about that one.

#2 should be fixed also.

Put a * in the shop field, does it work then? If not you'll have to modify the record source of the part number combo and add the Like.

Look at my example, it all works how you wanted it to, right?

No VBA, just in the 2nd form, make the defaults of the employee = [Forms]![NameOfYourForm]![Employee] and the default of your weekenddate= [Forms]![NameOfYourForm]![weekenddate] . Lock both of the fields and make the tab stop No. Here is an example that does what you want, just different...

You don't need the lookup table. Look at the properties - record source of the combo boxes, click on the ... button to see the query behind it. Using Like & "*" solves the nice to have also.

can you upload a sample?