Search results

I copied some of this from a consultant that helped us out a while back and I'm not sure why he did that. How do I use select case. I'm having a problem if I push the command button more than once. It doesn't seem to go through the if then statements the 2nd timee. It only sets the dates to...

I have a form with the following coding on click of a control. I am trying to always set ActiveXCtl0 to the current Monday when clicked. With this code, sometimes it works and sometimes it doesn't. can someone tell me what is wrong with my code? Dim stDocname As String, bteSte As Byte...

I like the idea of not compacting everyday, but I'm curious why doing it everyday is not good.

Only the tables are connected to the network. Users run the application from their C drives. I compact and repair every day. Could memory be a factor on everyone's computer? Any other ideas?

I found information on the PrtDevMode property, but do you know what would the code look like and where it would go?

Some of the forms in my database take up to 5 minutes to open. I do have subforms in some of them (not all of them). Is there anything I can do to speed them up? Once we're in, they move pretty quickly, just opening is so slow.

I have a report that I set the page property to legal. On my computer it always comes up now on legal, but all other users have to manually change it to legal after they pull it up. Can I do something so that everyone's report automatically opens to legal size? The other properties like...

I have a report grouped and sorted by load date weekly and monthly. On the weekly group header I would like to have a week beginning field so that it always has Monday's date for that week.

I tried it again and it works now. Thanks a lot!

I tried this too right after DoCmd.OpenReport stDocName, acPreview. On the next line I typed DoCmd.RunCommand acCmdZoom200 and I got the ssame error. Should I put I write it a different way?

I have been trying to open a report to automatically preview to zoom 200% using docmd.RunCommand accmdZoom200 on the OnOpen event of my report and keep getting an error that that the command or action isn't available now with Runtime error 2046. What am I doing wrong?

DBL- Thanks, I've gotten this to work well. But how can I make it work without a message box that the user has to push "OK" everytime one of the reports has not data. I would like the reports without data to be skipped.

I have a report with smaall type, 4-6 size font. when my report is previewed it is very hard to read. Is there a font that is more readable on the screen? Any other suggestions?

I have several reports that print at one time . I would like to only print them if they have data on them. I've gone to the NoData event on the report and put Cancel = True. It works except it gives a message that it's cancelling the open report. How can I stop this message? I think it's...

2 questions: When I go into preview a report that is formatted landscape, it previews side by side. I would think that since my page is formatted to landscaped that it would preview one on top of the other. Can I make it preview this way? And once it's previewd can I print exactly what I...

I have made a report with a lot of formatting: 6 columns, different margins, legal paper, etc. I also have my database secured. When I setup the icon on my users' computers the formatting doesn't work right. Mainly, the paper won't automatically go to Legal. I wish I could print this in...

It could show a value of 0 in my table, but it needs to show up as a "?" on my report.

This is what I want a field on my report to do: If a field in my query is "U" then I want a "?" to show up, if not then I want to sum what's in another field. I'm getting an error message that my expression is too complex because it uses numbers and variables. How can I solve this, it's driving...

I have a data entry form that users enter a Load date. I want them to be limited to only entering Load dates from Monday to Saturday (no Sunday Dates).

I have a form with 2 ActiveX Calendars that make up the criteria (beg & ending dates) for opening a report. I want the users to be limited to only choosing a Monday for the 1st Control (beg date) and only choosing a Saturday (ending date) for the 2nd control.