Search results for query: *

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

Hi PHV Excuse my arrogance, I've written it in like this and obviously it's wrong. Private Sub Form_Load() Me.Var.Value = FileDateTime("c:\Testing\") End Sub var is the name of my text box that I would like to display the timestamp in. Can you please tell me the correct way to use the...

Hi all, Does anyone know how to create a form within access 2k that will show me the last modified date on a folder? Let's say that my folder is called: c:\Testing Thanks in advance, Tadynn

Apologise for taking so long with a reply. Had internet troubles..... Tony Jollans, that was exactly what it was. After I added a space or two the query worked fine. So thanks for that. Gold star for you Rgrds, Tadynn

TonyJollans/Golom I removed the spaces and even copied the code into a sql query and all appear to run okay. I even removed all the spaces but still nothing. Golom, Steps 4 through to 9 even though they appear the same are actually different. The criteria is set by the area name. So step 3...

Hi all, Access 2K I'm having problems with a piece of code that I wrote to create two tables and append data to those tables once created. The problem appears to be when the code runs to steps 3 and 4 (see below) step 3 makes a table and inserts data and step 4 appends more data to the newly...