Search results for query: *

I am using the finfirst method as an after update event to set the active record from a query recordset. I am connecting through ODBC to a SQL server, which is a new thing, and suddenly having big problems with this one form. The form also includes a subform, that looks at the related records...

I administer an access db that I recently migrated to a SQL server back end, but are still using the access front end. I have a form that is used to apply payments to jobs- the form uses a query which looks at the primary table for the recordset. The form also includes a subform that looks at...

I am trying to set up an aging query, to show me the totals for a currency amount invoiced in a date range as a function of the current date, i.e. less than 30, 30 to sixty..etc. I wrote a query to do a datediff to come up with the age. Problem is, my boss wants all the totals displayed...

I need to make a combo box lookup values in a table, and also have entering data into the box write that dat to the table, while still saving the values to the table in use on the form. Is this possible? How? Thanks

I administer an access db that has 8 to 10 people using it at once, and I keep getting a "unable to update, locked by----" message, but I have specified no locks in db options on all the terminals. What have I missed? What causes this lock conflict, and how do I stop it? ICCPM

Is it possible to write a record from a form to two identical tables in two different files?<br>I would like to do this as a redundancy in case of data loss.

What are the best alternatives, to step up to the next level in a database?<br>

I administer a database used for entering, tracking, and billing freight shipments.&nbsp;&nbsp;It is comprised of two files, one is the data and the other is the forms and reports, etc...<br>&nbsp;&nbsp;The data file is now about seventy megs, and crashes way too often.&nbsp;&nbsp;I need to...

what is the syntax you would use to make a form find the greatest number value in a tsble, then add 1?&nbsp;&nbsp;I need to write this to avoid using an autonumber field, as replication wreaks havoc on my use of auto number(makes random instead of incremental)

I need to set up an access dbase so that it disallows editing of specific records after a yes/no field is updated for the first time. It would be nice to be able to override with a password, but not essential.&nbsp;&nbsp;How do I do this?-- will a macro allow me to change the properties of the...