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...

Access should be able to hold 2 billion records. Unless your computer is very, very old then it should be OK

Solved Thank you, Thank you, Thank you. You have made an old man very happy. That was exactly what I needed.

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...

Wow, that was quick. Many thanks. Never used Cross tab queries, I'll take a look.

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?

Ok, thanks that makes sense, but won't people then need to log in using the workgroup username and password as well as the one that I provided? I do 'stuff' with the information I gather when they use my logon, if I had to go through three and a half million forms to take all that out I'd be...

Hi, thanks for that, but Workgroup Security is probably much more complex than I need, plus as this is going on someone else's system I can't go messing about with their settings. My worry about the whole Workgroup thing is that it always seems to impose security across all the databases on...

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...

Excellent answers, I was using dir, but I'd missed the vbDirectory attribute. Many thanks.

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...

Thanks, yes I see that. Ideally I'd like to have that as a button on the form. So I included a button that has these two statements: RunCommand (acCmdRemoveFilterSort) Me.FilterOn = False This does in fact clear the filter from the record (I can then see all records), however when I...

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 don't know if you figured it out yet, but I had exactly the same problem. Its nothing to do with linked tables (I thought it was as well). There is a reply from ScotGem on another thread that solved it: "Set the Filter Lookup property to Always. you can find it on the Data tab for each...

OK, I had a feeling that it would be something like that. Cheers, Bernard D

Thanks for the quick response, however the file does not contain the name of the bitmap, that would be too easy. The bitmap will be called exactly the same as the text file apart from the extension. What I need to do is to intercept the filename as I am using the DoCmd.TransferText and use...

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...

Just for the record I've found a way of doing this. It's very simple and I'm sure that there are better ways, but this works for me. On the Switchboard form I've put three hidden fields, called myRed, myGreen and myBlue respectively with their default values set to the correct RGB values. On...