| Thread | Last Post | Replies |
|
| Help examples don't work in VBA 6.3 | 15 May 2005 02:19 GMT | 2 |
I am using Access 2002 and I have this problem that help examples don't work in modules. For example: "Dim dbs AS Database" won't compile. Can anybody help? Thanks.
|
| Copying External Objects (eg, Queries) when Starting a Database | 14 May 2005 21:30 GMT | 3 |
I want to copy some external objects (forms and queries, mostly), when I start a particular database. How is that done?
|
| debug question | 14 May 2005 21:26 GMT | 6 |
Another quick question: in debugging code, F8 takes your forward. Is there a way to back up one step?
 Signature sam
|
| Send e-mail showing results of query | 14 May 2005 19:03 GMT | 1 |
Office 2003 Professional I know how to use the vba SendObject to attach a query to an e-mail. What I am trying to do is use vba to create the e-mail and show the results of the query as a table rather than just attaching the query. Can this be done
|
| Generating a new Quantity using 'table.field - variable' | 14 May 2005 17:51 GMT | 1 |
I'm currently working on the stock control side of a database, at th moment I'm writing the code for transfer stock from one location t another, it basically works something like this DIM blah blah blah..
|
| run Shell with /wait | 14 May 2005 14:41 GMT | 4 |
I'm creating a cmd file I want to run with Shell which copies an existing file, performs an operation on it which will change the file size, and then deletes the original and saves the new file back with the old file name. After the cmd file finishes, I want to report the length ...
|
| DATABASE PASSWORD | 14 May 2005 14:11 GMT | 1 |
Getting difficulty to open a password protected database from another Access file via VBA. Please help
|
| pass integer to query statement | 14 May 2005 14:10 GMT | 1 |
I am trying to pass the value of ph.PatientID to variable lngPatientID as seen below. When I use lngPatientID in the next statement below, I get a type mismatch. Where is my syntax wrong? Thanks again. Dim lngPatientID As Integer
|
| Index | 14 May 2005 06:52 GMT | 1 |
I would like to use the Seek function to find the details in a table and then write it into a new record. Private Sub ItemID_AfterUpdate() Dim mydb As Database
|
| Return server name | 14 May 2005 06:24 GMT | 1 |
Using the file scripting library, I want to move a file off an intranet web server to a local folder. Is there a method to get the server name?
|
| Delete a group of records in VB won't work | 14 May 2005 06:21 GMT | 5 |
I have a waste to energy program I'm converting from Foxpro 2.5 to Access 2002. The history data file has several hundred thousand records, so I am writing the data initially to a temp file and when completed to the history file using a command button (Save/Print). Writing the ...
|
| Registry functions | 14 May 2005 05:59 GMT | 2 |
Can someone show me examples of the: GetRegistry function and the SaveSetting statement
|
| use one control to affect another | 14 May 2005 04:18 GMT | 1 |
I have a sub form that deals with registering people for events. These sessions are offered 16 times a year with 7-9 different activities each session. In my regestration form I have a date field and I would like to be able to
|
| Operator in SQL like "Like" | 14 May 2005 01:08 GMT | 6 |
I need to find an operator I can use with programming - the help says I can't use the "Like" statement, but I need to get the same results this would give me - is there an operator I can use? Thank you!
|
| passing a variable to a SQL string | 14 May 2005 01:01 GMT | 7 |
I have a sql string that contains variables the prtion of the string in question looks like: & "AND ((Phones.[Phone Type]= """ & PhoneType & """)) " _ This works OK if PhoneType is "Work" or "Home"
|