Search results

In one of the fields in your query enter this: NewValue:IIf(10>[numericfield], 10-[numericfield], 0) explanation: ( - condition- , - value returned if True - , - value returned if False - ) Peter

After 2 days' struggle I found some clue. My form "frm_Order" has a sub-form which lists the details of the current Order. I had this line after the Docmd.RunSQL codes: Me.refresh After I changed it to: Me.OrderDetails.Form.Requery error #2486 message doesn't come up again. But still...

Here is a strange problem I had never encountered before. I have a form with a few command buttons. One button runs a Docmd.RunSQL code which append some records to a table. Another button runs a Docmd.RunSQL code that delete some records from the same table. The table is a simple table...

I used to put a Command Button alongside with the record and simply put DoCmd.RunCommand acCmdDeleteRecord in the code. Add confirmation MsgBox if you like. It deletes the record on the same row. How's that?

How about: Declare a public variable in the Start module which stores the UserID when user logs in. Clear the variable when user logs out.

Hi Pat, RoyVidar, Thank for your advice. It's not a calculated field. I had removed all calculated fields in my dbs since I joined this forum, and had a lot of improvement on my applications. Thanks to all who contribute to this wonderful forum. My app was built with Access 2K, it worked...

It looks like problem with the printer or windows print spooling system, not with Ms Office.

Hi Happy YN, I just come accross this thread today. Some time ago i had posted a sample db here: DynamicXtabRpt It's a dynamic report but there are still some limitations. Is it possible that you could use VB codes to conditionally alter the print orientation and number of colomns when...

I finally found a way to make it work both in A2K and A97: I put a Textbox in the Form Footer to count the total number of records txtTotalItem = Count([Items]) Code: Dim x as Integer x = Me.txtTotalItem Do Until Me.CurrentRecord = x Docmd.GoToRecord, , acNext ....(my update action) Loop

Hi Cable, Yes you're right. The behaviour of the Recordset Clone in A97 is not the same as in A2K. In A2K I use Dim rst As DAO.Recordset Set rst = Me.Recordset Thus rst.MoveNext is the same as GotoRecord acNext In A97 I can only use Dim rst As Recordset Set rst = Me.RecordsetClone The Cloned...

Thanks Cable, Here is an example of what I am trying to do, and, it worked fine in Access 2K (with Dim rst As DAO.Recordset): I have a continuous form with say 10 records. When I enter "-1" in the [Adjust] field in the 5th record the code will automatically enter the same value into the same...

Try replace "'" & DOSETTE & "'" with "'DOSETTE'" Peter edited: Oh, I think it should be like this: "strSupLast Is Null Or strSupLast<> 'DOSETTE'") Hope I am not pointing at the wrong direction. :D

The purpose of my code is to update the records that follow the edited one in a continuous form, but I could not make it work. Here is the code simplified: ----------------------------------------------------- Private Sub Adjust_AfterUpdate() Dim rst As Recordset Dim n as Interger...

Could it be the Option settings of Excel or Access? Did you contact the manufacturer for technical support?

Although I have used the barcode scanner for many years I don't have much experience in programming the scanner. I suppose every scanner comes with a Configuration Guide in which you can find configeuration instructions. All the time I have been using the default factory configuration. By...

You can use Page Setup - Columns. In Column Size set the width to the width of your record text box. In Column Layout select Across, then Down. Peter

Basically it's a report that displays records in columns, group by [Color]. For the Headings I used a sub-report that draws the [Size]'s, which also displayed in columns, and I placed the sub-report on a position that matched the columns in the main report. All queries are simple select...

I am presently trying to setup a Check In - Check Out system for a factory with about 100 employees to replace the old time-punching machine. I put barcoded stickers onto the old time cards. The old time-punching machine will be replaced by a computer that runs only a Access mde ap. An employee...

Barcode is a very efficient tool in database applications, it helps to read and enter data much faster and accurate. Therefore I would like to recommend it to other Access application builders. Here is my experience in using barcodes with Access (Comments are welcome.): There are 2 stages to...

You're welcome, glad I can help. Peter