Search results

I asked a question yesterday (and got a quick answer) about how to fit report to window. My report still has a gray area across top and left side where the report doesnt completely cover all area. I can scroll the report to make it fill the page, but is there a way to have the report...

Yes, that worked great!!! Thanks to you

Thanks!! That worked perfectly!! Thanks again

I needed this code in a report of mine. However, I am using a switchboard to open report. So, I went to the onclick event and cleared the code that switchboard manager wrote and typed this back into the onclick event: docmd.openreport stCalendar, acPreview docmd.runcommand accmdzoom100 It...

It tells me that Microsoft Jet database engine does not recognize '[beginning date]' as a valid field name or expression. My report runs off of a crosstab query. I tried to go into the date field of my query and input Between [Beginning date] and [Ending date] but it also said it didnt...

When I open my report it asks me for Starting Date and Ending Date to pull correct records. That is exactly what I want, but I also want it to take the Ending Date and put it in an unbound text box to show w/e date for the report. Is there a way to do this, or is there a simpler way to get...

yes, thank you but I have tried that. I finally got the report to sort and group using that method so all names in each column would stay together, but it still starts column 1 (first shift) way down on the page, column 2 (2nd shift) is grouped together but closer to the top of the detail...

I made a crosstab query with these fields: Row heading : Date Column heading: Shift# Value : Name This gives me everyone by date and what shift they are on. And it works great! But, the report looks horrible. It has a person under shift 3 and on next line is person...

My report has a page for each day in my table. I want to have an input box when the report opens and input the date I want to start previewing. I tried to put [Enter starting date] in query but it wont let me go forward or backward from that date. (My navigation buttons are grayed out). I...

Thanks, Travis I learn something new every day!!

My command box wizard will not work on my report. It works great on the form but not on report. And the wizard is turned on. When I tried to write code instead of using wizard, the events were not in the property sheet!! The event tab is totally blank.. what is wrong?

yes, I did so many things trying to figure out what was wrong that I do believe I changed the recordsource at one time. Thank you for your help

Okay, guys...I think I got it!!! I was trying to put me.empname.setfocus and by chance I typed me!empname.setfocus and It Worked..... So, why did it work with me- bang and not me-period? I know that I should know the answer, but I dont. And thanks to all of you again for being so helpful!!

It doesnt seem to matter whether I put in me.empname.setfocus or empname.setfocus. It just will not recognize this code anywhere in the form.

I have checked the properties for both controls, i.e. empname and command10. They are set to enabled - yes, locked - no. I also tried to put empname.setfocus in the on current event of form. It gives me the same problem. The phrase empname.setfocus is always highlighted in yellow no matter...

I have attached following code to a command button to enter data in a form for my calendar. My only problem is the last line: When I click the command button, code runs fine until empname.setfocus. Then the line is highlighted in yellow and wont take focus of the command button. What am I...

Yes, I see what you are saying. I will take this info and read over it and THINK!! You have been very helpful. Thanks again, Doc Man.

First of all, thank you Doc Man for answering my post. I am very limited in Access, but am very eager to learn. So, your answer is great, I just dont' know what to do with it. So, let me ask this another way. I am thinking maybe a pivot table would work for me. I have a table that holds...

Please, Please help!!!!Populating fields I am trying to figure out how to populate fields in between 2 dates. I have a startdate and enddate that I fill in through a form. But, I want a query? or VBA? to populate the dates in between with the same info in that record. HOw do I do this...

The appointment scheduler is exactly what I need!!!! However, I dont need the time tables only dates. I will be using entire days. What I have is a table with Empname, shift, hours off, startdate, enddate. I have set up db to track employees requesting time off. I have a form that fills...