Search results

I think I may have messed it up. I saved the class as "NIRates" now I am able to see it but I was testing it at the bottom of modRate module and I'm getting this error "Object variable With block variable not set"

At one point, in another db, I was using Dmax, Dlookup etc but it had a time I had to pull a report for 10 employees for the year and that took forever to generate. With vba it takes about half the time but I believe it can be even faster if the 2 functions I have (one for ENIS and one for CNIS)...

I'm using the function in a query (qryWklPayroll). Here it is.

How do you use the class? Ok, this is how I want to use it: This is the NIS Rate table: +------------+----------+----------+-----------+--------+--------+--------+-------+ | EffDate | Class | WRange | MRange | ENIS | CNIS | ClassZ | NISID |...

Thanks @bastanu it works but it did not work the way I thought it would. I thought that having the recordset open already I can just pull the 2 values (CNIS and ENIS) and populate the fields with the values one time but changing the Reference field just made the function run twice, which is like...

I never fully understand how TempVars work and I know it is a very useful function. How do I use it?

I am sorry if i phrased the question wrong but let me explain. I am using a public function to open a recordset, It has 5 fields. StartDate, MRange, ENIS, CNIS, ZNIS Public Function EmpWNIS(inpGross As Double, inpWDate As Date, inpRDate As Variant) As Double Dim strPeriodEnd As String Dim...

That did it. Thanks @June7

Yes the combo is unbound and I was just experimenting doing the DCount after the ElseIF. The datasource of the form is the products table.

I know how to open "another" form to add the record if it is not-in-the-list of a combo box but how do I move to a new record on the SAME from that has the combo box. I have a combo box that selects existing items and once selected it loads the form with all the details but if the item is...

Yes, the combobox is referencing a second field. I don't think that having a local copy of the link table is possible as other users updates data on it during the course of the day.

I have a combobox that uses a barcode scanner for input. This is bound to a linked table on another PC on the network. The problem I am having is that after scanning, the combo box takes long to fill with the barcode. In latency terms, after scanning one item and I go to scan the other the...

It works. Thanks @MajP. Never even considered making a form event public. This opens up a whole new way of doing things.

After the barcode is scanned into cboSalesUPC, it is passed to a Combobox named sfSalesUPC in the subform. The subform is a continuous form named subfrmSales Syntax Error at SubFrm.cboSalesUPC_AfterUpdate() Error 438 Object does not support this property or method if I change it to...

I didn't want to pass it directly into the subfrom. I wanted it to go to the cboSalesUPC first then to the subfrom control. The reason is, I have some code in the After Update event of cboSalesUPC that I need to run before sending it to the subform control.

First, let me state I'm working with a barcode scanner. On my form (SALES) I have a Combobox (cboSalesUPC). As soon as the barcode is scanned, cboSalesUPC validates it and then it is sent to the field sfSalesUPC in the subfrom (subfrmSales). If the barcode is not found, it triggers an event to...

Oh, the tone of your post sounded like you were making fun of me. My apologies. I'm getting so many different ways how to go about this. On youtube, , Richard Rost used a Short Text data type for his UPC but you've learned from the start that a field that contains only numbers warrants a...

What's the issue here?? Is not the purpose of the Internet to do research? Why limit yourself to one forum? Maybe, just maybe there are other developers out there who can offer insight and different ideas. Or is it that some members in this forum feel that you shouldn't go all over the internet...

I may have to use this because even though I set up a price for 24 units (1 Case) I did not take into account 48 units or 36 units. So I will have to change my Products to have a separate PK and make UPC a Short Text to include things like "Case", "Packs" etc. Or have a separate column to have...

Yes, I was using the Barcode as the PK. I have to go back and fix all my tables 😖. Double allows for 15 digits and I might get 15 digit barcodes in my Product listing in the future so I will leave it as Double. Unless that's a bad idea??