Search results for query: *

I probably shouldn't be posting this here, but I don't know to which forum it belongs because I don't even know if this is possible. Could you from your computer fill in a form and then make it go to a specific internet address and fill in the data and submit it for you? Is that possible? In...

Hi I tried to use the hide access options from this script: Option Compare Database Option Explicit '************ Code Start ********** ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in...

Hi! I have an several unbound boxes, that calculate the final price for an order. The first one gets the subtotal from the subform the second one discounts the reduction percentage, the third one adds the VAT and the last one gets the transport costs and adds them getting the total. It's pretty...

I have a form Orders(tblOrders) with a subform OrderdetailstblOrderDetails). In the subform we can fin ProductId and BlowerId that come from tblProducts and tblBlowers. This way we can make one order and order several products. the thing is when I click on a button for saving the order and the...

Hi! I'm trying this to see if I need to make a new record or I just open the existing one: Dim stDocName As String Dim stLinkCriteria As String stDocName = "Proformas" stLinkCriteria = "[Proformas_OrderId] = " & Me![OrderId] If IsNull(stLinkCriteria) Then DoCmd.OpenForm stDocName, , , ...

I need to show only the records that match the criteria: Dim stDocName As String Dim stVal As String Dim stWhere As String Dim stFilter As String stDocName = "ProformaSearch" stVal = "='" & Me.SellerIdctrl.Value & "'" stWhere = "[SellerId] " & stVal stFilter = "SELECT...

Hi! I have a form that feeds on one table 'table1' and a report that feeds on the same table. On the form I have a button that opens that report, but it never displays because I get a JET error. Anyone knows why? this same method works perfectly with my other tables and reports.

Before the SQL is executed, Access displays a message asking permission to add a record to the table. This is usual when Access performs any action query, and can be suppressed with VBA code if you don't want your users to see it. Anyone knows this code? or where to find it?

I have a query with a subquery that works perfectly, but I need to filter it even more. this is my actual query: SELECT Location.Location, Location.LocationId FROM Location WHERE Location.LocationId NOT IN (SELECT Products.LocationId FROM Products) ORDER BY Location.Location; I'd like to add...

I have a form for making orders that contains a subform for the details of the order where I can chose several products for the same order. My problem is that whenever I try making a new order in that form they give me an error because Jet db cannot find matching Ids. Of course not, It's a new...

I'm trying to save a record and set one of its values when that happens. this is my code: Private Sub SvProforma_Click() On Error GoTo Err_SvProforma_Click Dim strInput As String Dim strSetTtl As String Dim strTotal As String Dim stLinkCriteria As String stLinkCriteria =...

I hava a form based on a table where a button opens a report base on the same table. In my other forms the reports (based on the same tables) work perfectly but with this one table no report opens. I've been checking the values and everything seems ok. Still I get an error that says that the...

I'm trying to open the print option on a repport. I want to allow the user to choose the printer so I just need the print window to open when the report opens. How can I do this? PrintOut prints it directly and that is not what I need.

I have a form that is reloaded as in edit mode with one button and in nonediting mode with another. But to avoid trouble with null values (in case the user has erased the value he was editing) I need to filter the exiteditmodebutton command: Private Sub ExtEditMode_Click() On Error GoTo...

I've got a repport with several subrepports. The important thing is that I need it to show or hide two of them depending if they have a value or not. I made this code for it, it works perfectly on a form but on the report it doesn't do anything ?.? I may be using wrong terms but I don't get any...

As a continuation of my previous thread: http://www.tek-tips.com/viewthread.cfm?qid=1123497&page=1 The code that works has a failure. Everytime there is a type that has no records related to it, the first row of products changes to that type. How could I avoid that? The code I use is: Option...

I have a repport with a catching error message box. normally when there are records to repport it shows the image per record, but when I filter it by the results on a form query and there are no records to repport the image module gives error. My code is as follows: Option Compare Database...

I have a report with a loop in details. I.e., there is a subform that shows how many products where ordered within one order. So in one order I have two products with two prices. Now I try to sum like I would do it on a form =Sum(([Price])+([Extras])) but it only gets the value of one of the...

I ahppen to be terrible with codes because everytime I try one on my own it gives me error so I really need help with this one. I have to make an order where the shipping address depends on a checkbox customerctrl. The idea is that if the combobox is checked the code will make...

Hi! I've got all my forms interacting through buttons that call the macro action to open the next form. The problem is that they don't pass the joint value. Like Seller form opens orders form with sellerid in common but it doesn't open the right order. I tried the where value [sellerId] but it...