Search results

Hi, I automatically create files via access, then I am sending lots of data to those text file (well an .sql file to be exact) as strings. I have the transfer working great, everything is working fine Print #iFileNumber, sTheDataIAmPassing What I want to have is a header on the page...

Hi, I have got a date created as a string (date) the output format of my code in VBA is dd/mm/yy ie 01/02/2004 I want to be able to get this into a dd/mmm/yyyy format ie 01-feb-2004 how can i do this? I know i can extract the month using month(date), how can i have this in a...

Hi, I am using the Aduit trail code (supplied by GHudson) Original thread I am trying to use this code in a subform aswell, in the main form the changes are logged with no problem. In the subform the changes are not logged. How can i record the changes made in the subform? Any help is...

Hi, I have used the following article to create a mouse button scroll lock : http://support.microsoft.com/default.aspx?scid=kb;en-us;278379 I have used the code which does not require an activex dll file (second part of the knowledgebase article). The problem I have is that when i apply the...

I have a combo box on a subform. The combobox gets the values from a lookup table. I have two fields in this table , Description and part number. when i try and use the combox, i can see the values of the table, however afterupdat i get an error message: "The field is too small to accept...

Hi I want to have the CurrentUser being set as the default value in a textbox. the control source of the text box is called "SignedBy" , I want users to be able to change the name in the text box from that of the logged in user (as people may work in a group of 2 people when using the form or...

hello, I have a database which has a part of it that creates serial numbers etc. A serial numbers is created from a combobox and 2 txt boxes. The combobox gives a letter, the first text box creates a date and the third uses an autonumber. The three boxes then have info extracted into an...

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...

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...

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...

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...

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...

Hi, I am trying to open a text file using a button which is set as a hyperlink. The file location will stay the same however the name of the file will change dependant upon a previous value in another field (basically this is serial numbering with referencing to a set history log). I have...

Hi, I am pretty new to Access and learning alot all the time. I am trying to create automatically a serial numbers for certain products. the serial number is initially dependant upon the type of electriconic Cards used in an product. ie, type 1 = A ,type 2 = B ,type 3 = C Next in the serial...