| Thread | Last Post | Replies |
|
| Cursor Jumps spontaneously in MS ACCESS application. How to fix? | 30 Jun 2006 23:10 GMT | 2 |
I have a stand alone application written in MS ACCESS. In Appointment form I have now the problem - cursor spontaneoucly jumps to the very left upper corner of form. What would be the reason for it and if there is a way to fix it?
|
| Rate this Post | 30 Jun 2006 22:31 GMT | 4 |
Why am I unable to Rate or Select Answered for posts? I am signing in with a valid passport but cannot see the options anywhere! Cheers, Steve
|
| SQL Like not working correctly when string contains # | 30 Jun 2006 22:20 GMT | 3 |
I am using Access 2003 to create a messaging program based on XML documents received from GPS units. I am forced to use the unit number and message text to match up incoming XML documents with my database records. I use the following SQL statement:
|
| Automatic Form Letters | 30 Jun 2006 22:08 GMT | 16 |
What is the best approach to automatic letter generation? While I'm looking at a record, I would like to generate a form letter based on the record and relating data, ideally with one click. I've tried both reports and forms and find limitations in both.
|
| Sending email gives 'application is busy' error | 30 Jun 2006 21:47 GMT | 3 |
I have an Access application running on a server where the user can send an email to an Outlook user from Access. This all works fine except sometimes the user gets a message that says: The action cannot be completed because the other application is busy.
|
| comparing fields in multiple records, and then doing calculations | 30 Jun 2006 21:05 GMT | 1 |
Hi everyone! I've been doing a lot of work lately in MS XLS, but I need to move a custom fuction I wrote in VBA from XLS to Access. I'm still trying to learn the inner workings of Access. What I need to do is compare fields and if the fields meet certain criteria I then need to ...
|
| Date | 30 Jun 2006 19:31 GMT | 10 |
I wish to receive a result date in this form: yy (06), only the two last numbersof the year. The problem is i always receive it yyyy(2006), even if i change it to yy. It's possible to solve this?
|
| No match in recordset | 30 Jun 2006 19:21 GMT | 5 |
In access 97, there is a nomatch method that allows you to handle a seek that does not contain a matching record. What would be the equivalent in Access2000?
|
| TransferText fails if there is quote | 30 Jun 2006 17:47 GMT | 2 |
Hi I am using the TransferText method to import a CSV file into a table. Everything works fine except when there is a quote in the field values Eg.:
|
| REQUERY or REFRESH | 30 Jun 2006 15:51 GMT | 3 |
Microsoft Access 2002 Windows 2000 Need to refresh records in a form from another form. Actually, I have to do this from two places. I am in a calculator form and trying to refresh records in another form with only a main form. Then I am in a calculator
|
| how to write a function | 30 Jun 2006 13:19 GMT | 3 |
how to write a function that will perform the below everytime i goto the next record or goto previous record i want it to perform the following codes if chka=-1 then txta.enable = true else if chka=0 then txta.enable = false
|
| FTP using Stuart McCall's example | 30 Jun 2006 13:04 GMT | 1 |
I downloaded the db from http://website.lineone.net/~smsburnley/ ; and I am getting the following error: ->MsgBox Err.Description, vbCritical <-error occurs here>
|
| Duplicate records on subform | 30 Jun 2006 12:38 GMT | 6 |
I have a subform that gets its data from a query. That query consists of 2 linked tables. When the query is run and the two tables are joined, the output consists of duplicate Empl_Names. That is, Ellen has 3 records because there are 3 issues. On my subform, it displays this ...
|
| Help: convert a Variant data into an Access table | 30 Jun 2006 11:00 GMT | 1 |
Hi all. May I ask a question here? I am modifying data which was developed by some other guys a long time ago. They get all needed data into an Variant variable, say AVariant, which includes headers in the first record and data from the second one. Originally they copy the
|
| Base 10 to base 32 | 30 Jun 2006 09:41 GMT | 1 |
I was wondering if anyone knew of a code that could change a base 10 entry to a base 32 entry? I'm not sure if its possible but curious. VR, Red
|