Search results

great, just what i was looking for. I was searching under different names to "audit and trail" before posting a message (with no joy!). Thank you very much Ian

Hi, I have designed a db to record where and how certain pieces of equipment are stored and setup. The db is based on serial numbers etc. The basic equipment consists of a "Panel" (a big box to contain the equipment) and electronic cards. The cards can be setup in varying ways...

Thanks for the reply, i relaixsed this morning about the Me. methid, however this was not the problem. I had two different problems. The one with the config file (a picture to be displayed is selected depending on 3 variables) i believe was an actual error with access and the way it linked...

just found a thread by hedgeKam saying the following, sorry i couldn't see thread number Private Sub cmdChangeView_Click() Me.YourSubformControlName.SetFocus DoCmd.RunCommand acCmdSubformDatasheet End Sub hope this helps

i don't know how to do this in code, why not instead create the subform twice, once in datview once in form view. then with the control button, use subform1.visible = True subform2.visible = False etc make one of the subforms invisible as default any use?

hi i have a db with several forms and subforms. I have creatd this db from an old db i was making (development version if you like) I have a form with a subform inserted. On the subform are several check boxes. When Checkbox 1 is true i want Checkbox 2 to be false (and vice versa), I have...

ok, the cardsettings field was intended as a place to record certain jumper settings on electrical cards. It was mostly used as an end point for the sample db i posted. With there being several types of cards this will be impossible to have in one table. There are multiple tests which are...

I am wanting to link further tables to the card setting, such as test data (of which the card settuings appears on the test form). The testing depends upon the type of card and forms are to be used to enter the data. I am trying to think of a good method to link these tests forms into this db...

Thanks for the region advice - i will impliment that. The cardtype in two tables was a mistake - it should only be in Cardsettings table. Can you tell me how i can later query the system/db to find (for instance) in which ProjectNumber certain Settings are used? Thanks Ian

Hi I am putting together a dB which will be used in logging equipment to be sent out to customers using a barcode system . I have so far made a few tables so far which are linked in a one-to-many format. There will be further tables and fields to be placed in these tables (i don't want to do...

Hi I am trying to create a dB for a barcoding system. I understand how to impliment barcodes etc (getting the bars into numbers to enter data into the db). What i am trying to do is create a db whereby i can enter data about a customer, have a project number assigned to a customer, have...

thanks, that is v useful. Just a quick question, what is the query qryObjects being used for? thanks Ian

Hi, thanks for this. attached is part of the db that i am talking about. Changing the cardtype in the form changes the first letters of the serial num. The letter is sent back to the query, changing all values -have a look and see. Thanks Ian

Hi , Thanks for that, was missing the field name in the title. The first two letters in the form are now taken into the query. However the value of the first two letters is placed in every item in the field, not as an individual case . ie when the number is ao12345 for item 1, the whole field...

Hi, I have looked for this but with not a lot of joy. Can you tell me where I should put the code please? I have tried in the query in the field name but it treats it as an expression and adds the value of whatever i type in to every item in the field. Kinda stumped on this one. Thanks Ian

Thanks, sorry for the simplicity of the question, i am fairly new to access and am trying to develop new ideas for my db all the time. thanks for the quick reply and the good info Ian

Hi, I have a textbox in a form which is linked to another textbox in the same form to extract the first two letters of the first text box (using control source, ([textbox1],2)). What i want to do is to be able to link the textbox2 (the two letter value extracted from a bigger value) to a...

thanks :) :D

I understand that the value returned is an ASCII value, however my problem is that the ASCII value returned will be the full combination of the 3 fields and not values from the individual fields. I do not have the combination of the serial number (A060400000001) stored in a table - how could i...

Hi, I have created a serial number which is turned into a barcode to be used on some of my equipment. The serial number is made up from a letter which indicates the type of equipment, a date (mmyy) and an autonumber. e.g. A0604000000001 - Type A, June 2004, Number 1 the Field names are...