Search results

:confused: Hi there, I have a database used by 2 or 3 users, each with a separate copy on their laptop. The database is set to Compact on Close. On one of the laptops, whenever the database closes (or whenever we try to compact it manually) it gives an error message ; Table...

Hi folks, How can I programmatically determine the current directory of my MDB file when my main switchboard form is opened ? I can use the .name property to get the location with the DB name on the end, but is there any way to get just the directory ? I need to dynamically relink my linked...

Hello, I am looking for some help on writing VBA to import tables from one database to another. The database has two version - the Master copy will reside in an office - but some users will be out and about with a User copy, interviewing patients on laptops. At the end of the day (or week)...

Hello all - dont worry, I found a bit of code explaining the SPLIT function which seems to do what I want. Thanks, Peter

Hi folks, Looking for help here. I have written a routine to read in lines from a text file. The values in there are comma-delimited. I read them in one at a time using textfile.readline, which works fine. I have written two functions, Head and Tail, which split a string around the first...

Hi all, I've been creating a database for my wife's work over the last couple of weeks. I'm no access expert, but I am trying to help them out. This thing is going to be used in the real world, so I would like it to be pretty robust. Some comments by people in other threads I have started have...

Thanks to Pat and Mile-O-Phile for their answers. I am learning a lot about the process of putting one of these things together. It's been pretty hard as I'm learning from a book and it helps a lot to be able to 'chat' with you guys. Is it really always necessary to set up a lookup table in...

Thanks for that - very useful - I did not know it could be done. The reason I am using an invisible first column is that the book I am learning from does it that way :confused: Thanks, Peter.

Thanks for all the replies. Column 1 is the Autonumber field, but its the value from column two that I want to store. I suppose my reason for this is that if the user is writing their own reports, queries etc, it will make more sense to them if they are looking for an actual dose e.g. "1 tablet"...

Hi folks, I have searched for this issue, but cannot see it anywhere. I am trying to set up combo boxes for a field in my main table. The Lookup values for the field are as follows ; Display control : combo box Row source type : Table/Query Row source : tblDose Bound column : 2...

Hello everyone, I've written a form to allow users to select a text file. I then use the transferText method (with a predefined Import Specification) within VBA to import the text file. My question is - if I distribute this form to other users, do I need to set up the Import Specification...

Hi folks, I have created a data entry form with one key field (Customer ID) used to identify customers. I now want to be able to use the same form to view existing entries. In the View mode I dont want to allow the users to change the Customer ID field. In the data entry mode they must be...

Hi all, I have a crosstab query which summarises number of retailers by region (rows), and by sales (columns). Sales can be 0-10, 11-20, and so on up to 60+. I then have a report which displays the data in the crosstab query. The problem is that if a small number of retailers is selected...

Thanks Neil - that looks like exactly what I can do. Cheers, Pete.

Hi there. Thanks for your help, but I don't think I can use replication here - the master database has not been replicated, just copied using Windows Explorer. Anyway, the master has 11,000 entries in it, and the copy has only 9,000 of these. I want the info for the 9,000 records updated into...

Hello, Looking for some friendly advice - I have tried searching but have not found the answer to this particular problem. I created a database for some people recently. They have created a copy of the database, now the two different copies have been updated separately. They want the data...

Hi guys, I had searched for "File Browser" but found nothing useful. If I'd known to search for "Common Dialog Box" then I probably would not have had to ask - when you are looking for something and dont know what its called, its sometimes hard to know what to put in the 'Search' box. Like I...

Hi all, This is my first post here - I hope someone can help. I think there is probably an easy solution. I am writing some code to import information from an Excel spreadsheet into my database. At the moment, the user types the Excel filename into a textbox and presses a button to pull in...