Search results

Another Question Hi IMO Sorry just one more question. When you helped me set the initial tables up there were set up as something like C-0001 for the automatic number. I want to get rid of the dash or the full stop. I have scanned through the programming but can't quite workout where it is...

I want both of them to autofill from each different code being entered. Thanks heaps. Regards jodi

I think I want to be able to retrieve the information from the Customer number as opposed to the name. We have divisions of companies that we deal with where they all have the same name and the only distinction is 3 letters at the end of a 50 letter name. Regards Jodi

Yes that is exactly what I am looking for, but I need to have two sets of this on the one form. One for clients and one for repairers. What is the best way to achieve that? Jodi

Have attached. The form I am talking about is tblclient. It is still very much in draft format as I wanted to get it working before i make modifications to it. From here I also need to add similar information from the Repairer table. I will then create other fields that I have not yet set up...

Not sure if that is the best way cause as I mentioned before it is sort of working. To explain in Detail. I currently have two tables - one a list of Clients and the other a list of Repairers. I am sorting them using a unique number C0001 etc for clients and R0001 etc for repairers (we...

From the message above I don't think that really helps me in this instance. I have a Form with the following ClientID Company Name Contact Person Phone Number I want the users of the Dbase to have a printed list of all of the ClientID's and Company names. From here when searching for...

I have found this discussion very useful The one problem I am having is I want the form to do a lookup. I have it doing this and I want to enter say the client number into the client ID field and then the details for that client will be displayed. I have changed the data properties for the...

Next Adventure Hi IMO Thankyou once again for your help. My next adventure is to get the other table to be where items are registered for repair. So I am planning to create a form that will autofill select client details and the repairer details and then the rest of the information is...

Still in Trouble Hi IMO I have been through all of your checklist and I still can't find what I am missing. When I go to add a new record in the Repairer table it gives me an error saying no current record. If you can offer a solution I would really appreciate it. Kind Regards Jodi

IMO, Your a legend, I think I have almost worked it out thanks to your expertise. My next drama is when I go to enter into the form I get a record saying no current record. Then when I click on ok it says that the primary key contains a null value and cannot be saved. Once again I am sure it...

Help Again I have just added another table to the Database. I want it to do similar to the last one but with different format of Autonumber. I understand what you are saying about the event procedure but am unsure where to update it. Also I need to know the code to put the letter R at the...

Thankyou so much IMO. I thought it would be something simple for someone else, as I said earlier I am blonde and I do have blonde moments from time to time. Regards Jodi

I have entered the code that was mentioned and still it is not working. I had already done this, perhaps there is an error in it somewhere, I can't find it though. Thanks so much for your help IMO. I am posting the DB for you to see perhaps you can spot it. Regards Jodi

Hi Everyone Can anyone please shed light on how the two tables in the example of this post are linked. I don't quite understand where they get the links and in trying to create a similar table set up I can't get them to refer to each other. Regards Jodi

Ok so I will try that. What about the two tables. How are they linked. I have created a database with similar tables but cant get the tblcounter to work. In other words I don't understand it. Can anyone shed any further light on this. Regards Jodi

Customise number I have utilised the information from this thread to set up something similar in a Database I am creating. The example that was posted was excellent and exactly what I wanted to do. My problem is that I can't see how or where the tblalphanum and tblcounter are connected. - Yes...

How do I get a form to open to the last record. In the properties of the icon I have tried using the expression builder, but I can't seem to get it to work, it seems to add an expression but then the expression does not work and when I try to use the button I get an error message. Any ideas...

I am trying to assign each entry a number. The database has a number in place of BA4415 etc. I want to automatically assign a new number to the next record created in a form. Is there an easy way to do this or does this number have to be manually typed by the user each time. As far as I can...

Hi everyone, I am new to this forum, I have created a microsoft access database for my work. I am at a loss though, I need to secure the database so that certain users are able to add information to the forms that I have linked in the switchboards. These users must be able to add information...