Search results

Ok, fixed it. I went line by line with my back up form to see what was different. "Allow additions" was set to "NO" My finger must have slipped? Thanks everyone for your input! Tom

I tried this in my backup form. It still shifts to a new record.

Re: Need alternate color in both header and detail I know there is a way. I had a sorting issue a while back in a report. I needed put the groups in order on the report as 1,2,3,4. I could not use the sort because some time a group would be missing so it needed to be 1,2,4 (3 mising) but on...

Yes, checked it and it is set to allow edits when the form open in designed mode. I have macro that sets it to no after the first insert. I did this because when a user is entering a record, if they scroll their mouse, it would go to a new record. Setting it to no after the first field is...

I do have it unbound because i need to collect that information. It was working fine for a week this way. Ok, just to test it, I removed it and made it unbound. Still does the same thing.

I thought it said footer. You said detail. It still may work. You would just have to have the field in the detail section set to "can grow" and "can shink"

I would try it this way. Put another field in your query that assigns a odd or even number to you group. It would have to go alone with your sorting. In your report, since your header and footer would be the same size. strech that field over the whole section of the header. Force it to the...

I was working in my form and came up with this error. "You can't assign a value to this object " When I open up the form, it points me to the On load code. Private Sub Form_Load() txtCompletedBy = Environ("USERNAME") End Sub This was working fine. I removed the code to try to trouble...

if you have a blank in one of those fields, you will get a blank. I would put a default value of zero in each field so there are no blank. Also, I would put that calculation in your query and then pull it into your report.

You would have to go to each column and add the conditional format. Instead of using "Field value is" for the condition, use "Expression is" then put in your expression and use the same formating specs.

Hello, I know this is an old post but I have a follow up question. I used the same concept of "after update" to populate other fields on my form. Works great, well at least the first time. If a user makes a selection from the pull down menu, the address fields gets updated. If the user...

Yes, I figured that out. Thanks for the reply. Only a picture\logo has the embed or linked property. I was going to just make bitmaps of all of the users info (bar code) and embed that into the report but that is the the correct way of doing it. I am going to check out IDautomation.com. We...

The embedded option is there when you insert a logo\picture.

Thanks for the reply. I just don't see the option to embed the fonts. If I can't figure it out, I will check out www.lebans.com, does it embed the fonts or will i still have the same issue?

Hi all, I have an Access 2007 database with the pdf plugin. I have code that exports reports out as a pdf file. Each report has a couple of Bar Code fields. These reports gets emailed out to users. The problem I am having is that when the user prints out the report, the bar code font does...