Near the end you'll see >>>>> It's happening here <<<<<<< what I'm trying to do is check to see if there are any records returned from the sql if so step into the IF statement and produce a...
Hello. This is something I've tried to do several times in the past, without success...
I have a small Access 2003 mdb app that I've developed for a small biz. As they may changes and req...
Hi everyone:
I am trying to add an option to my Access 2000 application that will allow the end user to click a command button that would open up an InputBox so that they could type in an e...
I have a command button intended to save the record and subform records on a form.
The subform has code in the before update event that test for null values and prevents the user from pro...
Anyone have a VBscript to loop through a recordset of an Access table an mark all Yes/No boxes as Yes (default is No). I can connect to the database with the script, but can seem to find how ...
Windows Vista Ultimate, Access 2003. My Access application consists of a main form with a subform. The record source for the subform is a linked table. Users enter partial/approximate data as ...
Hi,
My table is in access, and I need help in transposing the following format:
Lodge# Year Jan Feb Mar Apr
1 2007 10 15 12 20
Into this:
Lodge# ...
I am using MS Access 2003. I want to have my database open up in maximized view when opened. I have a form open up on startup and I need it to open maximized. I created a macro and in that mac...
I am using access 2003 to open a spreadsheet with 250 sheets. Splitting those sheets into single excel 2003 workbooks and adding some data validation to them via VBA.
Everything was workin...
Hi, I have an Access DB that contains a list of individuals (agents). I also have a folder that contains Excel Spreadsheets with a file name exactly the same as the agent name in the Access D...
I am designing a Microsoft Access Database and i will like to write a VBA code to stop the security warning from poping up each time the application is loaded. i know i can set the security o...
I want to generate a report from the database in Access by writing some VBA code.
I will have a Form containing a text box where I can enter the ID, and by clicking "Enter" the system will ge...
Dear EE members,
I would like to call an access macro. This macro will call the vba function with the following code
to insert record from MS Server to Access table, but I failed to make it....
I need to create a formula so that a total can be divided by a calendar of only Week Days not Weekends.. This calendar needs to be based on a 4 - 4 - 5 callendar...ie..5 weeks in the months o...
I am querying a website which returns data to a new sheet in my MS Excel workbook.
I am placing this data into the sheet via QueryTables.
One column of results from the query returns langu...
Using Access 2003 I have a table with emails. The data was imported from a text file. I have to remove the double quotes from each email in the table. Lest say it is Field1, how do I remove...
I have a created an excel template that is filled with VB code from access 2003. I have a chart that is coded with a specific "Case" for 5 cells in that excel template. They all have the same ...
The below code is intended to delete the form record. The subform data is deleted via the "delete cascading records" relationship option. The button works with no errors and the final messag...
Dear EE members,
I have a link table in ms access, where it links to ms sql table in remote site via odbc.
Currently, my access application is running by scheduling the macro and batch file,...
I have an issue with a form I am designing in Microsoft Access 2003. It seems that no matter how I declare my variable, I get a type mismatch error.
Here is the section of code:
Private Su...
I current have a Visual Basic Module within MS Access that I output the results of an MS Acceess table to an MS Excel spreadsheet. My problem is my output is now over 65,000 records so I want...
I have a text box called Txt_Date_Opened.
Rather than have the standard error message that if a use does not enter the proper date I would like to prompt with a more helpful message such as...
I would like to write a procedure that will link all tables in a SQL I have named all of my tables beginning with "tbl" and all of my views begin with a "v". Is it possible to programaticall...
Hi
is it possible to add parameters to a query ?
docmd.openquery(testquery)
and then some how add a starting date or other data to the query
I have a tblMain that has a 1-to-Many relationship with 2 other tables, tblNotes & tblBills, related thru tblMain's PK 'MainID'. I have a Microsoft Access Form whose first tab is getting data ...
