Search results for query: *

I've tried Kill "C:\path\file.xls" ..and nothing happened I also tried SystemObject.DeleteFile "C:\" ..but DeleteFile is not even in my list of methods (which may mean I don't have the dll referenced) Any suggestions are appreciated! Thanks!

Hello everybody, It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow...

Hello everybody, It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow...

Hello everybody, We're all of the sudden encountering some strange phenomenon with Access. It has only happened on two PCs now but we're concerned it may start happening more frequently. Here's what these 2 infected PCs do: 1. A particular continous subform all of the sudden will not display...

Hello, I need to make ALL my forms read-only when a user re-links to an "archive" database. Since all of the forms need to be read-only, it doesn't make sense to have to figure out what forms are open and then reset its RecordSetType. There must be a more efficient (and less...

Hello, I need to reference the following embedded form from a general module, but it's not working and I don't know why!! Forms!frmJobDetails_Module!frmJobDetails_Tabs.Form!frmJobDetails.RecordsetType = 3 'set form to read only I've tried it these ways too...

Howdy, I am finishing up developing this project management package for my client in the construction industry; they want a data archiving scheme where they can transfer all the data of a completed job (based on JobID) to another database of their choosing, for purposes of archiving and proper...

Howdy, I want to requery a listbox when the user clicks over to the tab it's located on. Seems simple enough but the On Click event for the tab doesn't work for some reason with a listbox.requery (and there isn't a got focus for a tab control) I'm currently using the After Update event in the...

Can't I place a public procedure behind a FORM and call it from anywhere in the application? Could someone help me understand why I'm getting the error "sub or function not defined" when I try to call it from a subform. Thanks This is what's in the main form that I want to call from...

Hello, I believe I have tried every number type, every number format and for some reason my number field that has 2 decimal places is getting rounded to the nearest whole, and is storing that way! What is going on here???

Hello, I am trying to send a complex query to an excel spreadsheet using OpenRecordset-- and having no luck. The query is based on 5 other queries, most of them using aggregate sum functions. The big query works from the QBE so I'm wondering if OpenRecordset is not able to open a query based on...

Hello everybody, I am trying to let my users begin entering data in the subform before "officially" making a new record in the main form. Of course they will get an ugly message something to the effect "you cannot add or change a record becuase a related record is needed in...

Our endeavor to output several tables to a Word doc (via Word bookmarks and Word tables) as a means to generate contracts has been mostly successful except that 1) when I start the procedure, Access will intermittently open a second instance of the same db, then ask for the criteria value from...

Set aside network performance issues and "revision ease" and someone please tell me whether splitting a database is ABSOLUTELY necessary for a multi-user db to WORK. Will random errors occur, such as with event procedures and form/control references, if it is not??? I ask because of...

Hi, can someome tell me if I can use a procedure to look for a specific .mdb file in a folder, and if the file does not exist, copy an existing .mdb in the same folder and name it the specified file I was looking for? Say I'm looking for f:\Access\PMP\A2002.mdb It's nonexistant so I copy...

I get a random Illegal Operation Error for kernel32.dll when I toggle between records on my form, and I don't know why! The form is unique in that it has 3 continuous subforms with only one of them linked directly to the main form, one linked to another subform and the other linked to both the...

How do you do this? Obviously the new subrecords need to have the new main records ID as its foregn key and not the old main record, so how is this done?

Hello, I want to make only selected words bold, underlined, or italic within a phrase inside a label or a text box in a report. I can't find anything on this so I'm guessing not, but still hoping there's a way. Does anybody know how to bold, etc without bolding everything in the label or text...

Howdy, I need to refresh an unbound calculated control in a subform on the after update event of another embedded form within the main form - this is turning out to be more of a challenge than it ever ought to. I have tried requerying and refreshing both the subform and the control itself. I...

Some of our users don't like it when they click on a field with a phone number input mask that they must make sure the cursor is at the beginning of the field or it won't enter properly. Does anybody know a way to reposition the cursor to the front of the field on clicking it? Appreciate any...