Search results for query: *

Thanks alot for your help! I have decided to create a batch file instead, Regards, Chris

Hi all, I need help figuring out a way to check that all the computers on the company domain have a file existing in a certain directory (same on every computer). We recently edited the current login script to add this file to all of the computers, but need to know that it is definately there...

Hi Remou, that's perfect, thanks alot. Chris.

Hi, I have a form (frmRegistryFiles) and need to show records in order of the highest value first in one of the fields. The field is 'RegNo' and contains 4 digit numbers. I need the highest reg number to show first, then next highest and so on. I know there is an 'Order by' property on the form...

ItIshardToProgram, thanks, I havn't thought of that. I am going to place a table in the middle like you say and change everything from there. I think I'll do a copy of the db first because I've got a feeling this is going to be messy!! Thanks again, Chris.

Thanks for your reply again fneily, The only reason I have department in the scanner table is to filter and populate the computer name box. Not all computers have scanners, so if a PC didn't have a scanner, how would I know what department the PC is in?? Thanks, Chris.

Hi again fneily, Could I ask a favour and let me send you a copy of my database for you to check out? Because I don't think that this technique would be possible to incorporate into my database?? Thanks, Chris

Thanks fneily. That really helps my understanding of how tables work and I can see how to make my database easier for the user. I'll have a go at this technique and let you know if I have any problems. Thanks again for your help, It's much appreciated. Chris.

Thanks for your help fneily. I see your point I do have separate tables for: -Department (containing Department and Department code) -Computers (contaning computer name, model, spec, department, software etc) -Scanners (containing, department, computer name, model etc) I think I need to look...

Hi, I have 2 separate tables, the main table has a list of all the computers in the company along with details about them. I then have a scanner table which lists all the scanners and contains 'Make', 'Model' etc. along with a 'Department' field and 'PC Name' drop-down field (to show what...

Thanks mp9. I dont have the same records in each table. One of the tables only includes a select few, but if data in the field on the main table which includes all the records is changed, I would like the field on the smaller table to change to (if it exists). Is this possible? Thanks again...

Thanks for your reply mp9. I was looking at th relationship optons earlier but didn't really know what to select. I have tried selecting the 'Cascade Update Related Fields' option, however when I click OK, i get the error message 'No unique index found for the referenced field of the primary...

Hi, I have 2 separate forms, both have a field which I have created a relationship between. They both link to records on 2 serparate tables. However, when I rename the field on one form, which I often have to do, this doesn't update the record in the other table, which causes the data to be...

When I said 'form', I meant Word document. Sorry for the confusion. Cheers, Chris.

I used Trollbro's second code and it worked fine? To add to this topic, Is there anyway of opening a form in Read-Only mode?? Thanks, Chris.

Thanks for your help IanAble. That works perfect! Cheers, Chris.

Hi. I have a register form, which is unbound. When I click the command button to create a new user, it is supposed to use the Dlookup function to check that there aren't any records including the first name and surname in the User table. However, this doesn't work and the form still add's the...

OK. I will try that. Thanks for all your help. It's greatly appreciated! Cheers. Chris.

Hi Remou, thanks for your suggestion. I have it working now. I used the minimise code on the command button because when I did it on load, and then set the focus back to the opened form, it went round in a loop and crashed my computer! Chris

Thanks, I have tried the code below but it isn't working?? Private Sub Form_GotFocus() If CurrentProject.AllForms("frm_Software_Home").IsLoaded Then DoCmd.SelectObject acForm, "frm_Software_Home" DoCmd.Minimize End If End Sub Any ideas? Chris