Search results

you will need to clean your code a bit but that is what you need to refresh the subform, put this in your button Dim strSQL As String strSQL = "INSERT INTO tblOrderDetails ( OrderID, ProductID, Quantity ) " & _ "SELECT " & Me.OrderID & "," & Me.ProductID & "," & Me.Quantity &...

I get a run-time error 2105 same as before as it has vb code on the on open event to go to new record. Remove it and post it again. DoCmd.GoToRecord , , acNewRec have you tried my suggestion?

You might really need is to filter the records, try Allen Brown search tool: http://allenbrowne.com/ser-62.html

Sorry, now I know what you are trying to achieve. But I get an error in all your main form and subform when I try to open them. on the pop up, add to the ProductID item after update event Forms!frmQuotesGenerator.Form.Order Details Extended.Form.ProductID.Requery You will not go to a new...

To answer question 1. do a requery on the subform, i.e. Forms!frmQuotesGenerator.Form.Order Details Extended.Requery Now I am not sure what you are trying to do by your second question, but let me understand better, are you trying to synchronize the pop-up with the main form? If that is the...

I several times had that message and it is caused by incorrectly referencing a field in a query or table on the vb module. But without the code and the table/query it references it's only guess work, based on personal experience.

Just looked into it, seems that I will need to purchase the Access 2003 Developer Extension. Some how I don't see it happening at the moment. Probably will have to work in Excel for the time being, oh well :mad:

Sorry, I am currently using Access 2003. I was leaning towards Access, but was not sure how I would deploy it. Thanks I'll look into the EXE file. :o

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

Thanks, I'll try this approach :D

If there is no path when you look at the location, I hazard a guess that the file is stored in your current front end of the database. Check to see if the other users have the file stored in the same location as their database front end. If that is not the case then maybe the path is wrong as...

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

:p I feel such a fool, I sorted it out now... Too many hours peering through it and I think my brain was fried. I put the form as a subquery and created on the master page an unbound combo box with the values, after that I apply the discount on combo box 1, which replicates the value in combo...

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

every time I stepped through the code it went straight to the Message box MsgBox ("No Errors"). Actually as I needed to make it work fast I used DAO in this one. I used Dlookup, which is fine as it's only an administrator task, so speed is not an issue, I ended up with the following: Public...

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

Sorry for replying late, I was away for a few days and only looked at it again now. Each table has a Posted Yes/No field and a PostedDate field. I load a recordset using ADO and pull out the data from each table where the Posted field is set to false. After posting the data into the xml file I...

the problem I have is that I just want my application to run the code, load an xml file and append to it, when finished to look for new records and append to the file if new records exist, if no records exist to wait a while then look again. Can that be perfoprmed with the timer event?

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 have a series of lines of code below that refer to the sub openConnection and CloseConnection.Each sub opens a new recorset that is used to output tree nodes to an xml file. I use it to iterate to our tables and then send the information in the right order, to be processes by an external...