Search results

I'm stumped and spinning my wheels like so many Milwaukee drivers after yesterday's snowfall. I have a series of forms named Survey1, Survey2, Survey3, etc. I also have a form for recording notes. When I close the notes form it is meant to post the notes into a hidden memo field on the survey...

I'm working with a SQL Server back end for the first time and am trying to make all the necessarry changes to make my ACCESS front end work. One error has me stumped. We've always had a standard set of buttons we use on our continuous forms. The form is AllowAdditions=False, the Add button and...

This is a very minor problem. But it's one of those things that will bug me to no end. I have a discount field on a pop up form whose format is set to percentage. The field it is bound to is also set to percentage. When the user entered, for example, 50, the field would change to 5000%. So...

Thanks, Pat, that worked. And shhhh, I'm not the one that named the fields. (:

How can I build a date in a query that is used for filtering purposes? The data is in the records in two fields - Month and Year. In our query we have an expression that builds a date - DateRange: [Month]/1/[Year] in order to qualify the record with the criteria Between FromDate and ThruDate...

Thanks Paul! It works like a charm. It's also a lot simpler to use. I know I will be using in the future. Mike

I have a report that opens by a DoCmd.OpenReport statement. To build the WhereFrom filter I iterate through a list box with the following statement: strWhere = "TableID = " With Me!VPProjects For intI = 0 To .ListCount - 1 If .Selected(intI) Then...

This is one of those problems that can be compared to a thorn in your foot. It's small, but it's still slowing me down. When I run the following code: strAbrevMonth = Format(intCurrMonth, "mmm") strAbrevMonth is always sey to 'Jan.' Even when I hardcode a 9 into the statement, strAbrevMonth...

We've been having problems printing reports. When printing from certain PC's some reports stop printing before all the pages have been printed. Other reports will print all the data, but stop printing lines and borders. We had similar problems where lines and borders were not placed in the...

We would like to give the users of our Capital Budget Request database the ability to link to any supporting documents they may have. In order to do this the documents must reside in a common area on the network. We can tell users where to put their attachments. But I don't really trust...

For anyone wondering, I needed to add an = to the variable name. The report exports to the correct file now. But the checkboxes from the access report don't show up. Any ideas how I can handle that?

I have one form with numerous buttons, each to print a specific report. I wrote an OutputTo Macro for use on a toolbar to export the open report to Word. I store the report name in a hidden text box on the Main Screen. Can I use variable such as this in a Macro? Right now my object name...

The form OnError event was the answer!

Thanks Rich, I'll try that. I was stuck on the text box error events.

The error takes control before the BeforeUpdate event. I still can't trap it.

dcx693, sometimes the obvious is the hardest answer to find! Thanks.

I have a text box that is formatted to military time. The user does not like the awkward cursor placement that occurs when using an input mask. So I took the mask out. If I enter a value that is not formatted correctly, I receive a microsoft error. I tried to trap the error in the after...

I have a form with a hyperlink that links to a word document. The link works fine but when I close the word document, the form is always minimized. This seems like a simple problem, but it's one of those little thorns I tend to spend too much time on. I put a DoCmd.Maximize into the link's...

Your right. We've got some catching up to do. fyi - The problem wasn't DoMenuItem vs RunCommand. SaveRecord wouldn't work in 2000 because the form was set to AllowEdits=False. In 97 SaveRecord works no matter what state AllowEdits is in.

In our conversion from 97 to 2000 we have had to change the line of code : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,,acMenuVer70 to: DoCmd.RunCommand acCmdSaveRecord. This works fine for a converted database running in 2000. But since our users have not all been upgraded not all...