Search results

So you mean if they need a new report I could just make it and run it here, then send the generated report to them? Rather than sending them the actual report? Mmm this could be one way of doing it....ideally I would like to send him the actual changes to the DB. Thanks!

Hi, im currently working on a database which is for someone else. Whe it is handed over to them, they will no doubt want some changes done every so oftern eg new reports, changes to forms etc. What is the best way to do this? The database holds a lot of data, so I dont think its feasible for...

Hi, im currently working on a database which is for someone else. Whe it is handed over to them, they will no doubt want some changes done every so oftern eg new reports, changes to forms etc. What is the best way to do this? The database holds a lot of data, so I dont think its feasible for...

correct code "[Username]='" & Me![User] & "'"

Hi guys - Im currently working on a login screen. I keep getting an error with this line of code: If Me.Pass.Value = DLookup("Password", "DatabaseUsers", "[Username]=" & Me.User.Value) Then its saying run time error 3075 -missing operator in query expression! any ideas? cheers

Will I have to do this in the query?

Hi there - I have an accounts form which shows a datasheet of the accounts table. I already have a text box which shows the total of the 'amount' field: =FormatCurrency(Sum([Amount])) Now, I am trying to do a total 'this month'. Can anyone offer me any help for this?

Hi There, I have a form 'Players' which has a field called Contact. When adding a new record to the Players form, the user has to select an existing contact or add a new one (they cant just type in a name). (There is a contacts table) So, i want a button next to the contacts field.I want it...

silly bugger, didn't have a folder called backup created du! Thanks t you

I've checked that but i think its ok?! Can you have a look: sSourcePath = "C:\" sSourceFile = "db1.mdb" sBackupPath = "C:\Backup\" sBackupFile = "BackupDB_.mdb" Set fso = New FileSystemObject fso.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True

Hi there, ive been trying your backup code out of interest ! I seem to be getting a "path not found" error on the fso.copyfile line? any ideas?

Sorry, no category is in Class!

If anyone has any ideas that would be great - Im lookin for a process to get info from a website to the database - one idea i have had is to have the info emailed to me then imported to the database is this poss?

mm yeh i think that may be slightly unreliable too. I have pondered using online entry forms? But I have been struggling to find out who complicated it is to access the database from the web....

classid is the primary key, and is an autonumber, so no duplicates. It is category i want in the combo! Maybe i have to leave out class id in the select statement on the combo box...

Hi Guys, I've been pondering over a problem for a couple of weeks now - We receive around 1000 paper entries to our competition, and these all need manually entered into the access database in a one-er. Is anyone aware of any ideas of how this could be made easier, and more automated? Thanks.

Not really much to it, regarding this anyway! I have a table - 'Classes' Two if its fields are called classid and category. On one of my forms I have an unbound combo box which I wish to fill with each category. With the code above, all the categories are loaded into the combo box, but I...

Sorry, that doesn't seem to make a difference?!

Hi, Can any1 give me any clues as to what is up with the following code- SELECT DISTINCT classes.classid, classes.Category FROM Classes; The combo box still shows up duplicate values!!

Hi there, I have a database in Access 2000. I need a load of info exported to word for editing, from a report. I know that when you export a report to word that you lose any images, lines etc. But is any actual information affected? Thanks!