Recent content by paulhenley

Thank you all for your help - I'm nearly there. I have tried many different options but cannot quite get what I require. What I would like is all the property names as columns across the spreadsheet with values for each field in each row. Is there a way of achieving this? Perhaps it is just my...

I need to list all fields within each table and include each of the fields properties ie Field Name, Data Type, Description, Field Size, Indexed etc, etc. I would like to do this in Excel - is there a way to get this data? Any help would be greatly appreciated

David, Thank you for your help. The Data Entry was set to Yes, I changed it to No and all worked OK. The strange thing is that I know for definite that I did not change this to Yes (well not directly anyway - I don't know if the system has done it automatically somehow) I could not even open...

I have a form with subform that was launched in two modes (add & edit). I used a separate form to enter search criteria that then opened the main form with items that matched the data enterd in the search form. All worked very well, but all of a sudden my main form now only opens in add mode...

Jim Many thanks for your prompt response and kind offer. I have actually managed to fix the problem by getting the data to default as you suggested by using the BeforeInsert and I put the code to calculate the next item number on a subform control GotFocus event. Many thanks for all your...

Jim, Many thanks for your suggestion, it solved the problem and all "If" statements now work. The only down side is that the default data (including the calculation of the new item number) does not appear until the user starts to enter data. I have tried putting commands in both the OnCurrent...

I have a form (header) that has a subform (items). I have some code that takes information from the header and populates the item table as default values when a new item is added> Private Sub Form_Current() If Me.NewRecord Then On Error Resume Next 'It should never occur, just to be sure...

I have a form that has a "duplicate record" button which allows the user to copy a selected item and create a new record. This works well and even selects the next item number when adding the copied record. All was OK until I added a requery command on controls that appear later in the form...

Fizzio, I think I have already done what you state, ie = Forms![CTL]![ctlquoteno] CTL is my main form and ctlquoteno is the value that I want to get to set a field in the sub form. When I save this under the default value of the control in my subform all appears to be OK, but when I run my...

Please can anyone help? I have a form (Sales Header) with a subform (sales items). It is possible to have 100+ sales items within an order, so to save input time I need to be able to add a value in the header form that will be the default value for a field in the subform for each new item...

I have a sales database and one of the forms has the sales order header table as the main form with the sales item details table as the subform. I need to be able to allow users to search for records in the details form (subform) and when found, display the relevant information in the main form...

This is a real long shot and I am possibly asking the impossible, but here goes. I have created a MS SQL7 database with a MS Access front end. Forms and reports have been created with Access and I have used the developer software to create the runtime versions for users. I have now been asked...

I have created a form that prompts the user to enter a contract number. This then searches the contract table and opens up another form (contract) with all of the contract details ready for amendment. The problem that I have is that if the contract number entered does not exist, it opens up the...

Hello DBL, Is there any chance you could send me a copy as well? Sorry to pester you, but I have been trying to achieve this without success. Many Thanks Paul.

David, I have tried to use Dlookup but can not get it to work - Please could you help with the code? The details are Table Field Supplier suppid Order ordsuppid The order form is called CTL I want the ordsuppid to check if value exists in Supplier.suppid and...