Recent content by rdpress

Is there a way to determine if a user uses the “Close Button”, the “X” in the upper right-hand corner, to initiate a close form in VBA. I would like to initiate certain tasks if the “Close Button” is used instead of a command button on the form that will do other things before closing. I was...

I do not... except for an "Endif"

I am trying to create a pdf from a report and then open file explorer with the report selected within explorer - user will then drag and drop the report to a third party web-site. All went well. However now file explorer opens as an icon in the taskbar - clicking on it opens the window will...

I am using MS Access 2016. My command button wizard creates embedded macros instead of VBA code. I have the "always use event procedures" option checked on under "File/Options/Object Designers" area and I still get macros. I would really like the wizard to create VBA, if only to save...

thanks for the tips

I have been using Access 2000 for a long long time, I am trying to get used to Access 2016's navigation pane --- I am wondering if there is a way to make object details show in a single line - instead of under the object name. Any information would be greatly appreciated.

I am now having to move from Access 2000 to 2016 and the learning curve is terrible. After almost 20 years of using the 2000 interface, I cannot seem to grasp the new "ribbon-based" interface. Does anyone know if Microsoft or anybody offers a help-line where I can call with quick questions as...

None of our users can send send mail successfully to specific users at one Domain name. The users do not get any error messages -- the mail just does not get to the users at the other end. The folks I'm sending the e-mail to sasy our mail is not going to there spam account. This started to...

I have an Access 2000 mdb be and would like to create a table that will contain a two field record (TableName and RecordCount) for each table in the mdb. Any suggestions would be appreciated. I've already created a table listing the names using a make query on MSysObjects. thanks much

We have a gift shop and and small e-mail list - about 200 names, I don't see it growing by more than 10 or so a month. My wife wants to send out e-mails announcing sales or events - once or twice a month. Does anyone no of a good software package to handle this? I've got some MS Access skills -...

Currently I’m backing-up the back-end of my database every 30 minutes. We’re using backup software that simply copies then mbe file every 30 minutes. Up until now we could live with the potential of loosing up to 30 minutes of work. We are now considering adding a feature that is very critical...

Dim strCriteria as string Dim strDoc as string StrDoc =”rptTrainingRoster” strCriteria = "DateValue([DateofTraining]) = #01/01/2008#" DoCmd.OpenReport strDoc, acNormal, "", strCriteria Executing the above lines gives me the following Error Message “This expression is typed incorrectly or is to...

I am doing a 3-column report that has a group section for day of week. I’m essentially doing a menu for a three meals for an entire week, each menu item prints in the detail section, however the number of items per meal vary, so the day section /with columns varies, making it difficult to read...

I've got .wav file that I'd like to use for background music on certain pages, but it's like 6,000 K in size. What file formats does Frontpage except for background music and any ideas on compression of the file so it loads quicker? Thanks so much.....

I have some long pages in my web and as I scroll down, the banner and nav bar scroll along, is there a way to set the banner & nav bar to remain at top of page and just scroll through the body of the page, much like a header remains at the top of form in Access? wifey really wants this and I...