I am using SQL Express(2005)
I have a visual basic script that plays a wave file when executed. I have tried to call this script using the following:
exec xp_cmdshell 'C:\AIRRAID.VBS'
It seems to execute ok and returns a null in output but the wave file does not play. When the script is...
The filter seems to be working. I can see the query as it loops. Before I added the last line to close the query their were 65 records filtered in the query. I tried to export from the menu bar and still got 2659 records in my spreadsheet.
Sub ExportData2()
Dim db As DAO.Database
Dim...
I am getting an error: the action or method requires a table name argument
And the debugger goes to this Line: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, qryOutput, DestDir & FileName
I have created the query.
I need to select a range based on the text in cells.
For example if I have five cells in a columm that have "Oregon" in them I want to be able to select all five with a macro.
I have an access form for adding new vendors. The vendor number is not autonumber it is just a text box. When adding new vendors I get errors if the ID already exists. How can I Check after update of the text box if the ID already exists in the source table?
I have an Excel Spreadsheet with a pivot table that is linked to an Access database that keeps track of which databases users enter and how long they have each one open.
The problem that I have is when users switch databases the information shows up wherever it wants in the pivot table rows...
I'm not following what the form is used for besides criteria for your query. Does your user set the values for the two fields in each record? For instance would they set the first box to 5 and the second one to 1 for John and then move to the next record for Brad and set them 3 and 4, and then...
If I understand correctly by adding
Or is Null should return what you want.
Criteria for Score Type 1
>([Forms]![Rpt_Form]![Score Type 1]-0.01) Or Is Null
Criteria for Score Type 2
>([Forms]![Rpt_Form]![Score Type 2]-0.01) Or Is Null
This will zip your mdb file. First download the winzip command prompt file at http://www.winzip.com/wzcline.htm
This assumes that winzip is installed on drive C: under program files\winzip and that the mdb file that you want zipped is in C:\databases by itself. It will create a zip file named...
Zipping open database is not a good idea. When any changes are made during zip process corrupt files are the result. Especially if you are trying to zip this from a macro or VBA code. Best recommendation is to install winzip, close database, locate using windows explorer, right click on .mdb...
Keep the shift key pressed when opening the database.
Then check the references by opening some VBA code e.g. by opening a module.
Check for libraries with a name starting with "MISSING" and uncheck these.
When necessary replace such a library with a newer/older version.
I am assuming that chkAdjust is a checkbox linked to a yes/no field in a table or query.
I am also assuming that optWho is an option group linked to a number field in a table or query.
and also that if the check box is checked one of the options in the option group also needs to be selected.
if...
Animation In Access - Using animated GIF's
faq181-108
Animated GIF's in Access
You will need an ActiveX control for this.
Go to this location:
ftp://ftp.simtel.net/pub/simtelnet/win95/graphics/
Scroll down through the list and download: agv10.zip
This zip file will contain 3 files. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.