Search results for query: *

I want to create a do loop in a recordset where I want to change the field that is being updated from Field01 to Field02, Field03 etc. on each loop. rst2.Edit rst2!Field01 = intUpdate rst2.Update I've tried a few things like setting a variable to replace the Field01 so that the code would...

I have several inventory items such as Tshirts that have various sizes and colors. Instead of creating a separate item code for each one, I would like to create only one item, identify it as a matrix item and be able to track the quantity on hand by size and color. I know a lot of programs...

I have seen several questions on the sharepoint site regarding an inability to view a list in datasheet view. Since I have several computers I have been able through a process of elimination to identify the problem. On the computers where I am able to open up the datasheet view correctly I...

I have a routine built in to my Access application to send an email using Outlook, does anyone know first hand if this routine will also work with Outlook Express?

I need to make sure another frontend application is closed before commencing to do a compact and backup of my database backend data. The front end where I have my backup routine is called VC.mdb and the front end that I want to make sure is closed is called SMP.mdb. So how do I close SMP.mdb...

I want to create a paper cut on a EPSON T88 thermal printer in code. The printer manual has the following code for doing this in Visual Basic, however when I try to run this in Access VBA I get an error that the variable "Printer" is not defined. Printer.FontSize = 10 Printer.FontName =...

I need to copy a table from one backend database (Source) to another (Destination) from my frontend. I tried using CopyObject but it only allows me to set the destination database and not the source database. Since the table that I'm copying is a linked table to the front end when I ran the...

I have a backup routine that compacts and zips the backend before opening an application. This process can take anywhere from 2-5 minutes. I would like to be able to check the zip drive file to see if a backup was already done today and if so skip the compact and backup routine, however I do...

I am exporting a table that has a cost field with 3 decimal points to a text file. The table exports fine except that the cost are ouputted with only 2 decimal points. I reviewed the export wizard several times and didn't see any place where I could specify the number of decimal points.

Is it possible to override a printer's default page length settings in code? I would like for this report to print with no page breaks.

What is proper syntax to rename a linked table? Backend table is also an Access table.

How can I delete one linked table in Code? I tried setting the the current db to the linked db and then using the delete object method, however all it does is delete the reference to the front end. It seems as though I'm not pointing properly to the backend db. I'm using Dim db as database...

I am printing a report in HTML, however the report breaks up into several files emulating the page breaks I have on my printer. I have tried changing the page length in the printer, using a continuous form but with out success. The best I've been able to do was change the paper to legal length...

Is there a way I can block the user from closing the program by using the windows close button in the upper right hand corner of the window? I want the users to only be able to close the program through the close button I have on the form.

I just created a new table in code, how do I link it in code to the front end. Table name "Titles

I need to modify a field in a linked table to make it bigger, I know how to add a field, but am unsure of the syntax for modifying one. Please help.

I have just started experimenting with Data Access Pages in Access 2000. I created a form to collect names, addresses, etc. I was successful in creating the form, howver the form only allows me to see the present records in the table, I can not add any new ones. I checked the properties in...

I copied a function that Changes a Query Definition from a book on Access. The function "ChangeQueryDef" works fine from the Debug window however when I'm try to use the function in a button I get a compile/syntax error. How is it possible to have code working fine in the debug...

I was developing some queries on a database that I didn't design. For some reason, even though I select only a couple of the fields from the tables for the query all the fields from the selected tables show up when I ran the query. Why is this happening and what can I do to correct it?

I have a button that I would like to make disappear after the user has pressed it. So far I've been able to make it disappear during the session by using the visible property, but the next time the program loads the button is there again. How can I make the button disappear permanently?