Search results

A barcode scanner (or at least the ones I've used) act no different than a keyboard. So what you're looking for is basically a textbox that would filter out a record in your form on its Before Update event. There are two ways that I use to filter: 1) filter property & filterOn method OR 2)...

I know a lot of people who "demean" access just because they're not educated enough about it. Access in my honest opinion is pretty stable. The only thing that would cause it to crash is user errors.

Share the code you got and we'll modify it for you

1) Get rid of all the autoexec related Macro's 2) Go to office button => Current Database => Display form and choose the form you want to load

CRUD: http://en.wikipedia.org/wiki/Create,_read,_update_and_delete

So you'll need a SubcontractID table with the following structure: SubcontractID, ContractID, StartDate, EndDate Then you'll need a payments table that will be linked to your subcontract as follows: PaymentID, SubContractID, PaymentMonth, PaymentAmount Am I making sense?

You're trying to accomplish so much at once that its overwhelmed you. Break it down, forget the whole inflation for now and assume a fixed rate for now. Do you need store every months payment? Or will a total field with the sum of all payments do?

Welcome aboard, anything in particular you're facing troubles with?

One way of doing it would be using SQL: Currentdb.Execute "INSERT INTO YourTableName VALUES ('" & me.myTextBox & "')" The above assumes your table name is YourTableName and your Textbox name is MyTextBox. Here's more info on INSERT INTO: http://www.w3schools.com/sql/sql_insert.asp

Check here: http://support.microsoft.com/kb/812718

I cannot see an attached file Anyways, to execute SQL code, you need to use the Currentdb.Execute method or Docmd.runsql method. I prefer the former. Enter that on the on_click event of your command button

Weird, I put the below code in my form: Private Sub Command7_Click() Me.Filter = "empid=" & Me.txtfilter Me.FilterOn = True End Sub And it did the trick. Sounds like a problem with your textbox settings

What you can do is, create a form, put a text box in it. And then on click of a command button (or before update of the text box itself?) you can execute that Sub procedure without the inputbox part. Sub AddToInventory() dim tb as dao.recordset set tb = currentdb.openrecordset("Select QTY from...

1) Split the database: http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx 2) Put the back end on your local server 3) Distribute the front end to all your users

Here's one way of doing it, enter the below code in a Module. This code assumes your table name is tblInventory, your Quantity field name is QTY and your Item ID field name is ItemID. Sub AddToInventory() dim tb as dao.recordset set tb = currentdb.openrecordset("Select QTY from tblInventory...

Yup, if you want to filter based on a text box, just remove the input box part and replace it by the name of your textbox. Let's say the name of your textbox is MySearchTextbox, and InvoiceNumber is the name of your InvoiceNumber field in your invoices table then your code becomes: Me.filter =...

Hmmm sounds like filter is your friend then. Try this: Me.filter = "InvoiceNumber = " & inputbox("Enter Invoice Number") Me.filterOn = true

Well you just told the form to ban edits, is that not what you wanted? If you want to lock a control or two, then the lock property would be the way to go, if you want to lock the whole record, I'd change the AllowEdits property.

Depends on your application really. You can even change that property in design time if that subform is never meant accept edits.

It's in the second line, you can't use "As [Date]" because Date is reserved for Access