Microsoft Access / VBA Forum

I am missing my main toolbar in MS access. the one that has, File, View, etc on it. I cannot get it back ANY HELP WOULD BE GREAT!. I even did a repair and that did not work

I have dates of service for several people that range all over each month. ie: patient had dates of service of: 7/3/2006, 7/24/2006 and 7/25/2006. I need to create a new field via a query that will convert each of the records of these service dates to the first date of that month, with results showing: 7/1/2006, 7/1/2006, 7/1/2006. How would...

How do I change the form view using VB after the form is opened? I am using the Switchboard pretty much as the wizard loads it. I've tweaked the appearance and a couple of lines of code but I don't want to modify it too much. When I try to load a form with the properties set to load as Datasheet view only, the switchboard's VB code...

In VBA (I expect VB would be similar) controlling another Office Application (Automation) can be done using the following steps : Ensure the Reference (VBA Window / Tools / References) has been ticked for the application you want to Automate. Set up an application object variable to use (You can use With...End With if you prefer). Either : ...

I need to create a basic one-dimensional array of strings, but I don't know how many strings I'm going to have until the code is finished looping. pseudo code: Dim astrMyArray() Do While Not rst.EOF i = i + 1 If rst!Something = Then astrMyArray(i) = rst!Something

Hi every one..I am trying to add 8 hours 15 minutes to current time and show the new time on a text box. How would I do that.? For example if the current time is 8:00am then adding 8 hours 15 minutes should show 4:15pm. Please help. Anna

I have created a form that has a few combo boxes on it. On the form I have ComboBoxA which selects data from a region, and ComboBoxB that selects individual locations within a selected region. I need to figure out the correct way to Requery ComboBoxA after I have updated it. I searched the archive for this list and found a simple solution:...

I apologize in advance - I know this is a basic question but I absolutely can't find a way for this to work. Currently I have a database I've made, with several processes of importing files, modifying the results, re-exporting files, etc. These are all done as part of a nearly-automated monthly process. Most of these monthly processes pull...

Is there a quick and dirty way to delete all files in a given directory? perhaps something like this: Set objFile = CreateObject("Scripting.FileSystemObject") objFile.DeleteFile "all files in C:\Temp" 'how to specify directory? Do I need to use the Windows API? Private Declare Function FindFirstFile Lib "kernel32 Alias...

Hi all! This forum has been very usefully for the Access Beginners like me. I believe my problem can only be solved in this forum. I have two tables (tblCustomers and tblOrders)and one form (frmOrders)for data entry, tblCustomers has the following fields: CoID (Autonumber) CustomerID (Text,PK) CustomerFullName(Text) The tblOrders has the...

Good day all, Can anyone enlighten me on how to switch between tabs in navigation form? My navigation form has 5 tabs, and for some reasons I need a code to switch, between those tabs. I have searched the web, but unfortunately nothing worked out. Thanks

I want to query on a date field for any date after today's. I've tried >today and >date, but Access won't accept those. I Googled here, but couldn't find any reference to today's date except in VBA. I hope I don't have to write code in Access to query relative to the current, or any other, date. Thanks!

As a lot of my projects involve using an odbc linked backend data source I have found this piece of code to be very useful. I usually trigger it to run on system startup like in AutoExec macro. It avoids any difficulties down the road with broken links and if the DSN name or database server changes then the only edit that needs to be made is to...

Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network lacation on a different machine, it tells me that the ODBC connection to 'SQL Server Name' failed. How can I create the linked table permenant no...

I am having difficulity with a form. I have a form with a sub form. I have a command button on the form that is to add a new record to the sub form. Can someone help with code for this. I have tried several things and nothing seems to work. I have searched and searched but have had no luck. btw teh command button can't be on the sub form....

I have an application with data on the server. Sometimes this data file remains locked even after all users exited the applcation. So the only option now is to restart the server, which is undesireble. The question is if there is another way to unlock the data file, whithout restarting the server ?

Hi, I am trying to open mdb file to view tables in it but when I open mdb file it run form in it by itself, as a startup point. Can anyone please tell me how to view and change in tables and forms, where I am unable to open them. Thanks in anticipation. Kid.

Hi everybody, Using Access 2003. I'm trying to dynamically set the record source for the current form and set the control source for a text box to input data to one of three tables. I have a form (frmAddNewUser) that will add users to one of three separate tables (tblDefsAFP, tblDefsMSU, tblDefsWF) based on the selection of an option...

HELP! I'm trying to check a form for missing values. Two of the fields are required and therefore the corresponding message boxes are VBOkOnly. The other two are for warning purposes and their message boxes are VBYesNo. First the code asks if the user wants to save the record. If the user answers Yes, the code should proceed to check for...

This is driving me crazy!! I'm using MSACCESS, and all I want to do is create a macro/query/anything that will take the data in Column A and copy it into Column B (same table) "Insert into" ALMOST works ... unfortunately it adds the data at the END of Column B ... and I need Column B to be an exact replica of Column A (but with a different...

Hi Experts, I just want to know if it's possible to schedule run macro in access 2003 automatically every night, so users can see the updated data early in the morning without have to wait for me to update it first? I have an access database that I have to manually run the macro everyday. If yes, could you please help me out? Thank you so much

I need some help. I need a button on an Access form that allows the user to browse for a file on our network, and insert it in a field (rather than having to type a path). I dont need any filters because the files can be any number of formats. I've come across a couple of so-called "simple" solutions, but for the life of me, I either cant...

I'm trying to import an Excel Spreadsheet into an Access Table but sometimes things get buttered up if the spreadsheet does not have the right columns. So I want to drop the Access table and recreate it with a DDL query when that happens. The problem is I get an error when trying to drop the table - Error 3211: The database engine could not...

Hi, I was wondering if the database file size limit was still 2GB in Access 2003? Does anyone out there who has been beta testing or a mvp have any info on this? Regards Mike

Hello, I'm a new user designing a simple database to retrieve pre-prepared docunents for printing. I have five tables, a form to design the documents, a form to customise and retrieve the documents, a query to pull the data together from the tables and a report which formats the document with the custom data ready to print. It works...