Search results

Thanks for the info Dave

Hi Guys I've got 2 general Access questions. 1. Can someone please explain the difference between DCount and DLookup. I've used both in a d'base I'm completing and as far as I can tell, they seem to do very similar things. 2. Is there a limit to how many workstations that can use one Access...

Hi Chris =Count([Name of Field]) should work. Are you sure [EarPlugs] is the EXACT name of the field? i.e. It's not [Ear_Plugs]. Try it with another field on the report, as long as there is a value for each line of the report, it doesn't matter which field you use. Dave

Thanks Pat, I had to change the query slightly, but I've got it working. Dave

Why not just delete the record with the cmd button? Place the following code behind the 'click' event; DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True The next record should then be automatically displayed. The 'setwarnings' stop access displaying a warning...

Hi Guys I have 2 tables - TblCostCode, which lists all available cost codes and TblPhotocopy, which users can enter jobs. Each job has a cost code. I want to be able to list all of the cost codes that haven't been used between certain dates. I can display all of the cost codes that have never...

Thanks for the reply AncientOne, but for some reason it seems to be working now. I can't understand why, 'cos I haven't changed anything. It was working on Wednesday, Thursday it wouldn't work, and today it's working! :confused: Thanks for your help anyway. Dave

nobody????

It's ok I managed to get it sorted. Thanks for your help Sue. Dave

Thanks for the reply Sue, but unfortunately it still won't print properly with the report open.

Hi Guys I have several reports, all of which need to be printed out. In order to make the reports 'more meaningful' I have a textbox on the report header that shows the type of report and the dates. I've used the following code in the control sourceof the txtbox: ="Report For " &...

Hi Guys I've created a form with 3 textboxes, TxtStart, TxtEnd and TxtTime. The user enters the start date, end date and the amount of days that the job takes. TxtStart and TxtEnd use a short date input mask. After the user presses the 'Search' button a query runs and a report opens, which...

You need to use the input mask feature on the text box properties. You can then set it to short date which will be in the format you require.

OK, Thanks once again guys

I think I've worked it out - tell me if I'm right. I open the database on one of the user workstations. Split the database using the wizzard, and browsing to the directory on the server where the backend will go. I then copy the front end to each users workstation. Is this right?

Sorry, one more quick question. I did a Microsoft VB course last year and we created a SQL database (as a backend) and the VB forms were the front end. One thing we had to do was put a bit of extra code under each cmd button i.e. to do a batch update, connection string etc. Do I need to do this...

OK Thanks Vassago I've had a look on Access help and if I'm looking at the right thing (Database Splitter Wizzard?) it should be ok. Thanks again for your help guys.

Who's right??? Thanks for the quick replies. I know it's better to have a fe/be but as the db is only going to be used by 6 people, I didn't think it would be a problem. Pat - The users are only going to be entering new records/data, they won't be updating any of the data that is already in...

Hi Guys I'm just about to finish the database I'm creating and as it's my first 'live' project, I'm feeling quite pleased with myself. It's only a small database that will only be used by 6 people. 2 administrators who will run reports, and 4 users, who will only be able to input new data...

Long Post Hi Pete I had a similar problem with a database that I created last year. It was a database that is used to store digital photographs. I'll post what I did and hopefully you'll be able to change bits to meet your needs. The form searched for *.jpg; *.bmp; *.gif; *.pcd; *.png; *.php...