Search results

I have a database set up tracking work accidents, etc. They have had me set up several reports showing various information, which I have pulling from various queries. Now they are wanting a COUNT of all records on each reports. Doesn't seem that difficult but I can't figure out quite how to do...

Thanks for the suggestion. I tried that but I get #Error in the footer. ??

I have a database set up tracking occurrance reports. They have had me set up several reports showing various information. Now they are wanting a COUNT of all records on each reports. Doesn't seem that difficult but I can't figure out quite how to do it. I set this database up 6 months ago...

Ok that makes sense. They didn't overlap at all, yet it was still leaving space. Not as much as when I had them as combo boxes, but it still left an extra line or two.

I changed all the fields to text boxes but it's still leaving a separate line for each possible field, even though only one of them is populated. Pat, I'm not exactly sure what you mean by overlapping controls. Can you clarify a little for me? Thanks!

I had to do this, though I'm not sure what the Avery # was for this. Are you using the labels option in Access? I couldn't figure that one out. I ended up setting up a blank report and getting one label to print in the correct place how I wanted it. Then I just selected everything and copied...

I have a report where I want one of five fields to populate the same area...only one of them will actually have info entered into it, the rest will be blank. I thought I could change the Can Grow and Can Shrink to Yes but apparantly that's not an option for a combo box? I need these fields to...

I have a form that asks in one field for a UserID, from a table called Users. Another field in that table is called UserName, and I'd like to have that automatically populate with their name when you enter the UserID. I know this is possible and is probably relatively simple, but I'm having no...

Has anyone ever told you that you're absolutely amazing? I knew it was possible, but BOY this works slick! Thanks a lot!!!

I have a basic table called ApplicationFunctions with 3 fields in it: UserID ApplicationID FunctionID I enter however many application/function combinations each user has access to, so there could be many records with the same UserID. I want to be able to copy everything with a certain...

Never mind, Jack! I must've typed something wrong because when I re-did it, it works exactly like I want it to. Thanks a lot!!!

Thank you for your help. I ran into a snag, though. I entered the code as you typed it, but I get an error message when I enter a UserID on the form. The message is : "Microsoft Access can't find the macro 'Me!UserID." Any ideas? Thanks in advance!

I have a form with 3 fields for each record....UserID, ApplicationID, and FunctionID. I'm entering multiple records for each user and am trying to get whatever UserID I entered last to default in the field on the current record. For instance if I entered UserID:kbrooks ApplicationID:PA...

I posted this before with no response so I'm hoping this time someone can help me out. I have a database set up to capture the applications and functions each user has access to, for security reasons. I have 4 tables... 1. The user table lists user id, user name and user department. 2. The...

That's exactly what I do...leave the query alone and within the report use the sorting/grouping options. Works slick.

I have a database set up to capture the applications and functions each user has access to, for security reasons. I have 4 tables... 1. The user table lists user id, user name and user department. 2. The application table lists each application id and application name. 3. The function table...

I have a database for patient information for use when our regular system is down. It assigns a "downtime" account number, and the user enters in all other information. Currently for them to go back and edit a record, they need to scroll through all existing records looking for a specific...

You can base a form on a query? I was thinking that was just for reports. Have to give that a try. I tried the orderby on the form properties but it didn't seem to do anything. Will give this first suggestion a shot...thanks!

This seems like a really silly question to me but I can't figure it out. I know how to sort on a report...but is it possible to sort on a form? I have a form that lists one record per line. I want to be able to sort them by a date field named DateOfService to make things easier to find for...

Thanks, guys. Chris, I tried your suggestion and I got a compile error when I tried to open my form. Pat, I'd like to try your suggestions but I need a little more help. I'm not sure what you mean by the OpenReport method or how to word a Where Clause. Also where to add the code you gave...