Search results

Thanks, I seemed to have soted it now. I created a module that holds the string connection. and refer all mu subs to open that connection

Now I get another error "Sub or function not defined"? I just thought of something? do I need to re-define the sub or functions for each form? And if that is the case would a sub be better than a function in terms of performance and re-usability?

Then I don't understand how it works in my form1 when I run the code :confused: I'll try and change and see if I get any luck.

I am having problems with this code, not sure where i am going wrong. My code looks for values in a table prior to appending, if no records are present in the table an error message is displayed, allowing the user to choose to open a form to input new data in. I get this message: "Argument not...

I am not in Australia but if the TFN is unique to an employee, then it is the attribute of the tblemployee, which you have correctly on your table. But the relationship between tblemployee and tblEmployeeBusiness should be of 1 to many optional same as for tblBusiness. Your tblEmployeeBusiness...

I figured it out just needed a few changes in the code. Dim varOrder As String 'Set current orderNo varOrder = POPRS.Fields("OrderNo").Value POPItemsSQL = "SELECT tblPOPItem.* " & _ "FROM tblPOPItem LEFT OUTER JOIN tblStock " & _ "ON tblPOPItem.StockID =...

I am trying to append to my XML file but I keep getting an error message saying "data type mismatch in criteria expression. I think the error is somewhere within my sql string for POPItemsSQL, but I keep on getting the same error message every time. varOrder is a variant that holds a order...

the file is formated specifically so that you would have to navigate to the specific node of the tree and append it as the last child of that node. I am still unsure in how to proceed. The application that collect the xml file for processing can rename the file after processing, so it might be...

We are planning to run a series of sales orders in Access and export this data as an xml file, as and when they are created, so instead of overwritting the xml file we need to append to it new data as and when the new orders are processed. The application can only read from one specific file...

I finally figured out how to append to my XML file using the XML DOM Reference. We use an application that reads an XML file and uploads the data into Sage Line 50. We are planning to carry out a series of order processing using Access, to stop a lot of the errors and solve some of the speed...

I am not sure if that is possible, but I am running a script in MS Access 2003 that retrieves a series of records from a query and outputs them to an external xml file. I created the tree and the child records. this is the format on the xml document: <Company> -<Products/> -<Customers>...

Sorry forgot to add, yes it is Access 2003, might try the HotFix and see how it works.

I am trying to create some labels using the label wizard. They are set at 100x13 mm and 150x13 mm, the first having 2 columns and the second report 1. Each needs to have 15 rows using sheet feed. When I try to set the margins Access freezes and does not respond. The margins are quite small, I...

Yes but the problem remains the same I still have to program the permutations for each level of the class code, taking to the fact that a code will have up to 4 descriptions depending on the position of the letter and it's relationship to the other letters, it would not be possible to input each...

problem is every letter has it's own description. It's all dependent on a code that the supplier uses, but as they change all the time we decided to do them on the fly and change them with VBA for ease of maintenance, . So the code goes : AAAA field 1 is assigned the first letter of the code...

I have a query that returns a few calculated fields and also uses functions, I am having a problem with the speed that the query runs. Part of the data is external to our system, since we receive it from the supplier in an Excel spreadsheet and as they are constantly changing the way they assign...

Assign your shifts to your drivers using the table Shift, where StaffID is a foreign key. You can add further shift types in the Shift_Pattern table. Use a parameter query to retrieve information between table Staff and table Shift. Use shift table, add extra field that shows if staff is...

I would also be tempted to have the entity shift (table shift) as follow: Shift ID Shift_Type Date Hours StaffID (Foreign key) Pattern you would have your early, late and so on, the date assigned to that shift and staffId as foreign key. But looking at it as it stands a staff member is...

You will need to map out the business rather than the outputs that you require. The outputs will come later for consideration. A business requirements documents is what you would need to produce or requirements gathering exercise. Right down everything that is of interest to the business in the...

I might just but in , but in shift you have early, day, night and so on, in my understanding this would be part of attributes patterns, they would not be attributes themselves. So a member of staff would cover many shifts what's the relationship on the other direction? is there optionality? Does...