Search results for query: *

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 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...

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...

I would like my users to be able to double-click a text box bound to a memo field and run spell check for that specific field. Currently I have a function that selects the current record and runs spell check on it, but I would like to limit it to the a single text box (the one they...

I'd like my users to be able click a button on a form that automatically starts camera software and saves the photo they take with the client information. In desperate need of ideas on how to automate this. It sounds like I need to store the photos outside of the mdb and have a text field in my...

I've split my database into a frontend and backend. The backend resides on on my server, it is mapped as M:drive on all my workstations. The tables in the frontend all linked to the frontend by statinng drive, directory, and file: M:\usr\frontend\ccmp_fe.mdb A copy of the frontend resides...

I posted in Tables & Relationship Forum some time ago with no response.. Sorry for the duplicate entry -- but I'm confused -- please help When trying to setup a one-to-many relationship with referential integrity, I get the following error Message: The operation failed. There are too many...

When trying to setup a one-to-many relationship with referential integrity, I get the following error Message: The operation failed. There are too many indexes on table tblClientInfo. Delete some of the indexes and try again. The ‘Help’ button has the following message: The operation failed...

I am creating a data with that will be primarily names and addresses. (I can not forsee ever having addresses outside the USA). I am not certain of the best way to handle the 'State' field. Is it best to state up a TblState, with fields the abbreviation and maybe fullname. Would the Primary key...

My clients have to attend 15 diffent class sessions. I have 3 tables, Client, Session, SessionHistory. I've created a One-toMany relationships between Client and SessionHistory,and Session and SessionHisotry. Tables Client: Key = ClientID ClientID FirstName LastName...