Recent content by Tadynn

Hi all, I've had this brilliant idea to create a map of our offices and be able to graphically map the locations of all our office equipment, connections, peripherals as well as other information such as ip addresses and a comment if the equipment is down. So far I've created a form and...

Hi there, Thanks very much for your replies and I apologise for not replying sooner. I successfully figured out how to run my code through access by writing the following code (thanks to Molby as I referenced what you had written to develop it.) I still am having a few problems though. I get...

Access 2k I haven't yet seen anything really good on this question so I thought that I'd pose it myself. I create a lot of queries as excel spreadsheets because they are far easier to sork with for clients etc and unfortunately, not everyone has access. A write a lot of little functions...

Hi, Using Access 2k I've got several scripts that I run that use the DoCmd.OutputTo function to output data from temporary tables in access into new excel spreadsheets. My problem is to do more with formatting. I want to automatically create a heading and insert a date so that my report...

Hi all, Using access 2k I have a form that is called "frm_Receipt", this form is set to data entry mode, and it's data source is a table called "tbl_RMADetails". Out of the 5 text boxes and two buttons on this form, two of the text fields ("serial" and "part") are required fields. To control...

Are your check boxes grouped together? i.e you can only check one box at a time? If so, then you could write a case statement to the frame that surrounds all the controls. Add to this a textbox that the query looks at to get it's parameters for the field 'Tier' i.e(SELECT * from [YourTable]...

Thanks RoyVidar, Worked well.

Hi Tony, I've just given it a quick go and it the looping worked well so thanks for that (I can't believe it was that simple). Quick question to go with this a bit further........ My output file is coming out like this (I've taken out the carriage returns to get rid of the spaces). "*FORMAT...

Hi all, Using Access 2K For reference, all fields listed below are text boxes on my form that are used in the code: LabelName NoOfLabels - No of times to copy recordset to textfile (loop) ProperShippingName UN_No PrinterName TextFileName I am currently have the following code attached to a...

Hi all, Access 2K Just wondering how far one can go to customize a toolbar in access. I want to create a toolbar with bigger buttons than access appears to provide and also to insert my own graphics as the ones that are provided - even though can be edited - are not really suited for the type...

Hi all, Using access 2K This I assume is a fairly simple one (except for me that is). My report that I run, ocassionally resets the page setup values that I have assigned it through page setup. I thought that a good way to fix this would be to assign the page setup values through code as part...

Hi Willir Thanks for your input. I've actually just tried another way of doing it and it worked. What I did was I created another main and subform with the relationship intact and then deleted the relationship in the relationship window. Because I created the forms while the relationship was...

Hi, Disregard, I've figured it out

Hi all, Access 2K I've written the sub below to create a temporary table when I open a form. Although I create the table okay, I haven't figure out how to also programatically create a one to many relationship from a permanent table (tbl_Manifest) to this temp table (tmp_ManifestDetail). I...

Hi all, I want to create a table that will have a structure (field names), but will contain no data. One of the fields I need to be an autonumber field formatted as "00000". Below is a list of the fields that the table needs to contain: TABLENAME tmp_ManifestDetail FIELDNAME DATATYPE...