Search results

On my database, I have a form containing details about PCs owned by particular people. Linked to this by the number of the PC in another form are all the peripherals attached to the PC. However, should the PC be allocated to a new Person, I would update the name field on the PC form. Is there...

Hi, On licking on a button to add a new record, i use the following code so that only a blank record appears,hiding all existing data. However, once a new record has been created, there is nothing to stop the user clicking on the New Record button. Can this be disabled as only one recird...

Thanks Rich Hi Rich, That works brilliantly. However, I only want Expired to appear if another field called ‘Call Type’ is set to either Type1 or Type2. If ‘Call Type’ is set to anything else, the Expired should not appear, even if it has gone passed the number of days? Is this a similar...

Hi, I am designing a call logging database. I have my form set to continuous forms so that all calls are listed and are easy to view. Should a call expire, I want an indicator to show to inform the user. This works fine when using a single form, but when using continuous forms, either all or...

Hi, Thanks, but I thought that at first, it doesn't seem to be that, any other ideas? Can i send you the database please?

Hi, I am designing a training database and have a training table linked to a lookup course list table which includes a memo field containing the objectives of each course. On the main training form, there is a drop down menu to select the course from the course list. Once the course is...

Thanks, That works perfectly. ;0)

Hi, I have unzipped this but it says I do not have the correct permissions to open it. Thanks Lee

Just a query really. We want to include a file path field in a form, but is there any way of being able to click in the field and search for the file using something similar such as Windows Explorer? Thanks Lee

I have used an unbound list box related to a query to show all related to records logged for a particular person. This works great but is there anyway of being able to double click on a record in the list and open the full details? Thanks in advance Lee

I am designing a computer inventory database and currently have a PC table linked via a one to many relationship to a Peripherals such as printers etc table. This works fine, but I have a disposed check box on both forms should we get rid of a piece of kit. The problem is if a PC is linked to...

I am designing a call logging database. I have a Computer Users table that is linked using a 1 to many relationship to a call logging table. On the call logging form, there is a button, that opens the Computer Users form to add new users to the database. However, in order for the combo box...

This may be really simple but is their a simple way to sort the order of records on a form, with the most recent records in terms of date being shown first? Thanks Lee

We have an email address field on our database. Is their a way make this field a hyperlink to pick up the address entered in the field? Thanks Lee

When I do a mail merge into word, the database opens another 3 versions of itself before the mail merge happens. Is their any way to stop this happening? The code I am using is: Dim objWord As Word.Document Set objWord = GetObject("J:\Admin\ISES\P_CapitaBookingForm.dot", "Word.Document") '...

Hi, I am designing an inventory database and have separated PCs from their peripherals. Is their anway of combining the two fields values in one combo box? Thanks in advance Lee

I have a main data form that can be accessed to view all records. However, should the user wish to enter a new record, I want to be able to include a button on the front screen that will open the data form, but with no existing data showing. Is this possible? Thanks in advance Lee

I am using the following VB code to open a mailmerged document and print it. This worked fine until we had to allow more users access to the database. We then thought it would be best to hide the database window so that nobody could mess things up. However, due to this, the mail merge code...

Thanks for your help. How do you check the references? Many thanks in advance Lee

Hi, When I try and run this code, VB will not let me as a message appears saying, "User-defined type not defined". Any ideas why not? Dim objWord As Word.Document Thanks in advance. Lee