Recent content by iccpm

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...

Petermeachem: How? I look at autonumber field properties, and it will not let me change it to increment from random- Is there another place to set these characteristics? Tks

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

I have already split the database into the front end and the data file, but I am glad to hear I can make a third file for backup...Now can I have the front end table write to both the backup and the data files simultaeously, or will I need to append the records periodically?

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.

I don't know that I was trying to make a point.&nbsp;&nbsp;I was asking a question.&nbsp;&nbsp;Is access at the bottom of the database chain?&nbsp;&nbsp;I am asking because i inherited an access database that is crucial to our production at my co. and is somewhat fruity.&nbsp;&nbsp;I am trying...

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

I am also interested in doing the same basic thing.. Please let me know how you make out, and how simple/expensive it is<br>thanks<br>nate

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...

how about the code to simply look up a number value and add one to it?

Well, I know it seems odd, but I am in a situation where I inherited a DB that another wrote, and somewhat short-sightedly.<br>The database is for tracking shipments of freight, and the autonumber field is our Pro#, or in-house tracking number.&nbsp;&nbsp;I need then to stay in order for...

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)