Search results

My database is split FE/BE, the BE being located on a local server. I have a report with a subform that also has it's own subform and it can take a very long time to print. The windows task manager will say not responding but if i wait it will eventually print. This same report used to print...

I have a access db that uses vba and works great on seven workstations, but does not function on the eighth. The database window opens with the switchboard visable, the buttons that open other forms from the switchboard work fine, but none of the vba (search records form, data entry form) work...

I have a few fields that are required in thier tables and have set the "Validation Rule" and "Validation Text". When i use a form that has these fields in them and break the "Validation Rule" i am getting the Access error message not my "Validation Text". I have gone so far as to enter the same...

Here is my question: 1.) I have a database (duh!!) which we use in our showroom for order entry. We then back up the db to CDRW and bring it to our wharehouse (weekly) to use for creating purchase orders, delivery tickets etc... The copy we use at the wharehouse only has one field that we...

Can anyone tell me why the following doesn't work? Dim db As Database Dim rst As Recordset Dim strSql As String OID = 415 strSql = "SELECT * FROM qryPrintPO WHERE OID = " & OID Set rst = CurrentDb.OpenRecordset(strSql) rst.MoveFirst Do Until rst.EOF strFilter = "Sku='" & rst!Sku & "'"...

I am trying to use the following: Dim db As Database Dim rst As Recordset Dim strSql As String OID = 415 strSql = "SELECT * FROM qryPurchaseOrder WHERE OID = " & OID & " ORDER BY Line" Set db = CurrentDb Set rst = db.OpenRecordset(strSql, dbOpenSnapshot) rst.MoveFirst Do Until rst.EOF...

I am trying to move the focus to a text box on a subform using the onClick event from another subForm. Here is the code that does not work, any ideas? Forms![frmChange]![DSP Lighting Inc - New Order Details].Form![OrdersDetails].SetFocus Forms![frmChange]![DSP Lighting Inc - New Order...

I have a db on which i use a switchboard for form/report navigation. Here is the problem: 1. I have a button that opens a search form and has an openargs value that simply tells the form what button was used to open it. when i open the form using this button i cannot enter values into the form...

I have a data entry form for new records only. I want to stop the form from advancing to a new record upon exiting the last field. I have other tabs on the form that rely on the data in the main form to complete correctly so i do not want the operator to be able to leave that one record any way...

Is it possible to include more than one value in the OpenArgs without having to parse the one variable into many?

I have three forms (Orders, OrdersNew and OrdersSub). Both Orders and OrdersNew have a button that opens OrdersSub, how do i detect whithin OrdersSub the form that opened it?

I have a form with a button (to open the report) and a check box (to say all sub-records). I have a filter in the sub-report set to list only one specific sub-record. Can i change the "Filter On" value from "Yes" (default) to no based upon whether the check box is checked? I am trying this: If...

When my kids don't listen, i understand. When my pute won't listen i pull the few remaining hairs from the top of my head!!! I have a filter in a report that has a subreport which itself has a subreport. I modify the filter on the main report and it works perfectly! I save the report, close the...

I have two tables related one-to-many. Is there anyway i can represent the order/suborder as 10000-A, 10000-B rather than using the suborder id like 10000-1259? In other words can i convert suborders that are number such as 1234, 1244, 1355 as A, B, C? I hope i have not totaly confused...

I have a report based upon a query of two tables. I am trying to have "Discontinued" be displayed in a Unbound text box next to any discontinued items. One table has a Yes/No field (formated as True/False) that is checked when the item is discontinued. My macro condition is...