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

...DoCmd.SetWarnings False DoCmd.RunSQL A DoCmd.RunSQL B DoCmd.OutputTo acTable, "tmp_ItemsAwaitingDispatch", "MicrosoftExcel(*.xls)", ExpPath & "SOH_Inventory.xls", True, "" DoCmd.OutputTo acTable, "tmp_ItemsDispatchedToday", "MicrosoftExcel(*.xls)", ExpPath & "Dispatched_today.xls"...

..." & _ "ORDER BY tbl_RMADetails.Part" DoCmd.SetWarnings False DoCmd.RunSQL A DoCmd.OutputTo acTable, "tmp_DailyItemsDisp", "MicrosoftExcel(*.xls)", "", True, "" DoCmd.SetWarnings True Step two, once the file is created. Is to run a macro in that I've created in excel to format the...

...Else 'Create the table DoCmd.RunSQL MakeTbl 'Output the data into Excel DoCmd.OutputTo acTable, "tmp_ItemsScanned", "MicrosoftExcel(*.xls)", "C:\Documents And Settings\tadynn\Desktop\Items scanned from " & Format([Forms]![frm_SearchTotal]![FromDate], "yyyy-mm-dd") & " - " &...

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

...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] WHERE [YourTable].Tier = Forms![YourForm]![YourTextField] Or IsNull(Forms![YourForm]![YourTextField]);. Then insert an...

Thanks RoyVidar, Worked well.

...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, " "ProperShippingName, " "UN_No, " "*PRINTERNAME, " "*PRINTLABEL" "*FORMAT, " "ProperShippingName, " "UN_No, " "*PRINTERNAME, "...

...String Path = Me.TextFileName.Value For i = 1 To NoOfLabels hFileHandle = FreeFile Open Path For Output As #hFileHandle Write #hFileHandle, "*FORMAT, " & LabelName & vbCrLf Write #hFileHandle, "ProperShippingName, " & Me.ProperShippingName.Value & vbCrLf Write #hFileHandle...

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