Search results

How can I build a SetFocus command on the fly? I am creating a Find form where the user can select their options. I am building the listing of options for the user to select from based on which form opened the Find form. All forms are set as Modal and PopUp so I have to set the focus to the...

This one has me stumped. I am trying to change the date criteria in a select query if the day of the month is the 1st day or not. If it is the 1st day of the month then I want the date criteria to be between the 1st and last day of the previous month. If the current day is not the 1st day of...

I want to sell one of my old computers. I know deleting and reformatting the hard drive will not actually remove my personal data files. I have been googling but I do not trust a lot of the stuff I have found. Can you recommend any freeware programs that will thoroughly erase the data on...

I am trying to use Bob Larson’s excellent Export A Form's Recordset To Excel code. It works of course, but I am using a datasheet view in my subform and I am hiding columns based on the users selection. I only want to export the visible recordset from the subform. There are over fifty...

Is it possible to print only page one of a two page report? I have a report that I want both pages to be printed for one instance when I send the report via DoCmd.sendobject acReport or open it via DoCmd.OpenReport but for another instance I only want page one to be printed. I have searched...

Anyone have a fail proof way to detect if a user has opened a database with a wireless connection? I found this code @ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23102110.html but I am not able to test it since I do not have access to a wireless...

Searching has left me dazed and confused on this one. I need a simple calculation to obtain the date of the first Monday of the current month in a field in a report? Thanks in advance for your help!

How can I detect if the current Excel 2003 file is opened within an Internet Explorer web browser and not within the Excel.exe program? I have an Excel file that is opened from a SharePoint site and all but a few of the 50+ users have no problem with the VBA in the file because their computer...

Can you tell why this is not working? I cannot get my IIF statement to work in the criteria of my query with the between dates I am using in my IIF. When I use the true or false parts by themselves, the criteria works in the query but I get no results when I use the IIF as listed below. This...

Any Access / Excel automation gurus out there? From Access 2003, I am trying to search an Excel worksheet and find and select the cell that has the text string "F Total". I cannot set a reference to Excel because some are not using the same version of Office. I cannot have anything done to...

I am trying to prevent a user from keying spaces, quotes and double quotes in specific columns. I have my code working to where I am able to replace the invalid characters but I want to warn the user with a message box each time I have to correct their invalid text entries. Where or how do I...

I have been away for awhile [working on other non Access projects] and when I returned today I see more spam ads than actual Access related posts in the General section. What the heck has happened to this forum in the last two months? Is anybody moderating this forum? :eek:

Security posts - merged Hi I've noticed totally different behavior with my secured databases in 98 and in XP. In XP Access Security works. In 98 it is broken. For example today I secured a database. I went to another computer running 98 and Access 2002 that was joined to the default...

I do not know of anybody who has installed any of the Windows Live beta's. I would like to hear from anybody who is using any of the Windows Live beta's. I am particularly interested in the Windows OneCare Live beta. I have to admit that I normally trust Microsoft products and hopefully the...

Is it possible to use the Windows Remote Desktop Connection between two Windows XP Home computers? I want a secure way of browsing between the two computers and I thought that the Remote Desktop would be the answer. I have just created my first home wireless broadband network with two Windows...

The ExportDatabaseObjects() function will allow you to export all of your database objects into individual text files for each object [tables, forms, queries, macros, modules]. You can specify where the text files will be exported to by changing the sExportLocation string to a valid path. The...

Here is a sample Access 97 db that will show you how to disable and/or enable the control box X button that most Windows programs have in the upper right corner. Sometimes we do not want our users to exit a database unless they have clicked our custom exit button. Disabling the X button will...

Here is a sample db that will demonstrate a variety of ways to accurately display the Record X of Y count in your form. Check the code I am using in the forms OnCurrent event on how I populate the various labels and text boxes. I also show you how to accurately display the Record X of Y count in...

This is just a quick resoration of my Browsing sample since the original thread and sample was lost when this forum was hacked. I am working on an improved version of my Browsing sample. Check back soon for I hope to have this thread updated. The attached sample db illustrates how to call the...

The below code will hide ALL menu bars and ALL tool bars. Ensure that you have a way to unhide the menu bars and tool bars before you hide them! You should place the hide all tool bars routine in your opening splash screen form for it only needs to be run once when the db is first opened. This...