Search results

Hi Wayne, The info required to be used as a header is just a string. I have this info from a text box on a parent form. What is the print statement to make the text a header on the text file? Thanks Ian (When i say header i mean as in header and footer -not just a title )

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

all i required at the time was the month, i have used this dd-mmm-yyyy format also elsewhere. thought of that for some other part of my prog after writing the thread - just thought it was obvious

sorry, got it now, I had tried the format function but didn't apply it properly. I missed the " around mmm and so nothing was formatted. for anyone else who does a **** up like this: now sDateInAlphabetical = format (MyDateValue, "mmm") -if the MyDateValue is a value 1-12, the equivalent...

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

thanks, completely missed that, d'oh! Ian

sorted it. It wasn't a problem with the code, a combo box error was occuring which made it look like when accessing the subform a problem was appearing. One of those "no, it can't be that" things! Consider thread dead

hi, it got ur demo version of the font install to work. I copied the tables, module and macro to my db. opening my db with the needed fonts (either installed or deleted), i get the an error when starting the db at the following line of the module (error code is 13) UploadFileToTable...

I have the Audit trail function working perfectly in the "stand alone" form of the sub form. When the sub form is being used as is intended on a main form(as a subform) the changes are not being recorded. Basically: When i make changes to data with the subform as a stand alone, all changes are...

that worked a treat :D thanks Mile-O-Phile

hi, i'm not sure if this thread is dead, i can't get the frmhidden to be hidden at the begining. it is always visible. How is this done? is there a setting i am missing? Thanks ian

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 wayne, Yes, I set the default value to =CurrentUser() in the table. However when trying to save this, it says that it is an unknown function as the default value. I can set it using Environ("Username") but this is the computer logon and not the Access db logon name. Any ideas? (I am...

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

Thanks pat, got that working fine now - much better without the update query. Thanks for the advice on date field :D

Ok - I have now got it to update a field with the combined values of all three fields. I am using an update query to store the values of all 3 fields to a new field. I am using the following sql UPDATE TblMakingSerialNumber SET TblMakingSerialNumber.BarcodeZusammen = [letter] &...

The trouble with that is that i am using autonumbers to ensure no number replication, the letters are to be chosen from a drop down list with is from a table and the date value is as default set to todays date, with the user able to change this as and when required. The three textboxes are...

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