Search results

Hi, I'm in the process of converting a complex database written in Access 2007 to a web enabled version. I would like to continue using the Access 2007 database as a back-end repository. The accdb file is encrypted with a password and I have no problems accessing it directly in Access 2007. I...

Hi, I have an Access 97 database that uses docmd.transfertext to import three text files when the use loads a particular form. It works fine. The line is: DoCmd.TransferText acImportDelim, "importProjects", "Projects", thisFile, False Now that I'm about to install the same db in Access...

Can somebody please tell me what is wrong with this code: userID = DLookup("[UserID]", "users", "([userLogon]= '" & Forms!frmLogon!srcUserLogon & "' AND [userPassword] = '" & Forms!frmLogon!srcuserPassword & "')") If isNull(userID) Then etc.... It works fine if the username and...

Hi, I need to produce a report in which some records are repeated ACROSS the page rather than down. If I was using Excel I'd just use Copy - Paste Special - Transpose. Is there any way I can duplicate this approach in Access?

Hi, I'm using Access 97. I have an Access application that consists of two databases, a front end witht he usual forms, reports, queries etc. and a back end with the data. I use my own simple logon form to restrict access at the front end, but nothing on the back end. I really want to...

Hi, I have one last thing to do on a database, and I can't see why this is happening. I use a filter by form, but when I first open the form, I cannot see the 'Look for' and 'Or' tabs at the bottom of the form. If I then use the form as normal and apply the filter, the results are what I...

Hi, I've got an Access 97 piece that imports text files, copies and moves the used files and several other things. I've now been asked to enable it to create a fairly complex folder structure. I've done that, but I'd like to be able to issue a warning if the root folder already exists, can...

Hi, I'm working in Access 97 and I've got a form that I want to use to create filters with. There are a couple of things that I'm not clear about and I'd appreciate any suggestions that you can make: 1. The form seems to remember the last filter, so when I click on the Filter by form button...

Hi, I'm importing the contents of lots of text files using a combination of a loop and DoCmd.TransferText. This works fine and I can get the contents of several hundred files in a few seconds. The files are called 1.dbb, 2.dbb... and each has an associated image file, 1.bmp, 2.bmp... etc...

Hi, I have a couple of identical databases in Access 97, they have lots of forms. My users use the two different versions of this database, but linked to different sets of data depending on what they are doing. I distinguish between the two versions by making the background colour of the log...

How do I get a cheque to be printed with the amount shown as separate words, ie change £135 to be one hundred, three tens and five pounds?