Search results

I need to design an order form to be distributed to all our customers. My problem is I don't know wether to use Excel or Access to achieve this. The underlining data will come from our database so they can look up the codes and enter the quantities they require. I worked mostly in Access for...

I split my database and it works fine, but I have a problem with my pass through queries. I have two front ends, one for usual users and an admin that is to sit in the server with timer controls. The pass-through queries are in the admin front end, but now if I run the pass through queries, they...

I have a form that I am entering data in the following fields: SKU | Qty | Description | UnitPrice | DiscountRate | CustomerID The user enters the sku and Qty, the system checks for errors and returns the Description if values are found. The user then needs to enter a discount rate to be...

I have used ADO regularly to access my data with not many problems. But I have been having some problems, with this code in particular: Public Function ErrorExist() As Boolean Dim SkuError As Boolean Dim sSQL As String Dim varMyErrors As Variant sSQL = "SELECT...

I want to schedule my application that on opening a form it will run a piece of code every minute, how would I go about it? I was thinking maybe looping the code and on opening the application the code would be run unless someone pressed a button to quit. What's the best approach?

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

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

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

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

I have some problem in getting to a solution for the best way to work at this. My management wants reports in table format, viewing expenditures and sales for comparrison purpose, so I am creating crosstab queries where the reports will be based on. My current line of thought is: 1. I have a...

I am trying to use VBA to create a procedure that sets the background Detail section of forms in white. For ease of updating I want it to be stored in only one procedure, and for it to be called from other event procedures when the forms load. Any idea how to implement it? I can do this in...

I run this vba code to allow me to filter data in a form. The form is bound to a query with ACCOUNT_REF part of the query and txtFilterAccountRef an unbound control box. I am trying to view a specific account with input provided by a user. I am getting an error message that says: "Run time...

I'm having some problems with creating some reports, The reports are to be based on what the parameter queries returns. They would need to run the following: Customer sales report: by customer,by year, by semester, bytotal sales, by brand, etc. If you where in datasheet view you would filter...

I have two queries: Query 1- shows all customers that have and do not have any orders in the system. Query 2-All product data that have or have not been assigned to an order. They both have the same fields. But not every product is assigned to an order and not every customers places an...

I have two tables, one Stock that holds all data on stock items. Another table, SupplierProducts holds additional data on stock items. The reason why is that the first table is an appended sage table, and the second one is a table with additional data for stock items provided by the supplier...

I need to create some reports using Sage data tables. I am quite confidente producing reports and normalizing but never before worked with linked tables and as this is my first major project, I am really learning as i go along. I started by producing a database analysis and design report for my...