Search results for query: *

thanks, r937, a second set of eyes always makes it easier!

I have never tried this before, but I was asked to create a calculated field based on information in a query. basically, if a field is blank, then select another field, if that field is blank, select a third. Here is what I wrote: IIf (LEN( [Remedy Budget])>9 , [Remedy Budget], IIf (LEN...

Thanks, PHV! quick, easy, and I should have seen that. You deserve the star I gave you.

I have built a form that filters data between two dates (start date, end date) as well as another criteria (site code). If the user puts in the start and end date, they can retrieve all records in that range, however, if they leave the date fields blank, they get no records returned. What I...

Prulite, not sure how this applies to the original posting, but... can you elaborate on the error at all? Can you get exclusive access to the database in Access 2007 and see what process is failing? I would suggest making a copy of the database and tinkering with it to try to figure out what...

Well, I actually took dhookum's advise, and beat my head against the wall until I figured out how to do a form/subform. This is doing exactly what I wanted (so far). Thanks again all for your help!

you lost me, PHV. Backing up, I created this second table (ISD_Lease2) to capture user input while leaving the asset data (ISD SACD1) alone. Since the table ISD SACD1 is purged and recreated, we wanted to keep the user input data in a second table, and link them based on serial number and part...

The reason the current primary keys aren't a 1-1 is that the ID field. You did however lead me somewhere else. I found that in the table ISD SACD1, there are null values in those two fields. Is it possible that since I am trying to join on those tables, and they are null, this is causing the...

I added both ID fields, and get the same results when attempting to update. note, the ID fields are not equal.

the two tables to not share a common PK. This could be accomplished by concatenating the serial_id field and prod_id fields (sadly, the vendor doesn't believe in a unique serial number for their hardware, so we need to manufacture one using the serial number and product ID.)

the primary keys on both tables are ID, which is a unique sequential number, different in both tables. Should the PK be changed to epserial_id & epprod_id?

yes, Access shows the PK on both linked tables.

I was just about to post it, PHV, since I do have a join statement see below: SELECT [dbo_ISD SACD1].epend_dt, [dbo_ISD SACD1].epasset_status, [dbo_ISD SACD1].[rStatus*], [dbo_ISD SACD1].rSite, dbo_ISD_Lease2.Luser, [dbo_ISD SACD1].smsComputerName, [dbo_ISD SACD1].smsLastLoggedOnUserName...

PHV, thank you for the article, what I gleaned from it is that I need to cerate a specific join: "You must specify an explicit INNER or OUTER JOIN between the tables. Joins created implicitly in the WHERE clause of the SELECT statement are not updatable." I think this is where my failure lies...

sorry, dhookom, I should have been clearer. I am going to review what PHV posted (when I get time to blink).

in my first statement, I stated that all bit fields were set to zero, and did not allow nulls. The relationship between the two tables is a one to one relationship. The first table (ISD SACD) is rebuilt twice a week to ensure data integrity, so the data is flushed and recreated. The second...

I have two SQL 2005 tables, ISD SACD and ISD Lease, both tables have a primary key assigned (all bit values have been set to 0, and do not allow nulls). I have created a form using a join between these two tables in Access. I am prepopulating two fields in ISD Lease to ensure the join will...