Search results

I get back "This Property is read-only and cant be set."

Hey All, I have a field "NameView", irrelevant but it grabs a name from a seperate form from an ODBC connection. The purpose for the field is simply to grab the data from another form. On the same form As NameView theres another field "Name" This Grabs the data from NameView and writes to the...

Is there a copy function in a query. I need to copy a field from the direct previous record in a table and have it loop till the end. Any thoughts? Thanks everyone. Your time is appreciated.

When you append to a new table for the CLosed items, make a new field in the query Date: Date() That will append the current date.

type sum before the (), make sure they are all the same data type

Do a Make table query with the closed claim criteria, Then do a delete query and erase it from the main table. Create a New DB, and drag that table into the new one. Or Right click the table, and click export, then click on your new DB. Erase the archived table from the Main DB.

You can append either way, if you still want to be able to manipulate that closed claim data, I would suggest appending to a 2nd database, an archive. Just Export to another database.

Add both tables into the query and drag the value you want to match across to the other table of the same field. Add all the fields from the 'other' table.

Hey Everyone, I am trying to make a pivottable but need to organize my data fist. I need to somehow append the Operator Name to a field on the same record of Jobs processed Example Please see the database under "qry_Trim" Current: $BOGLE (sca) (cca) (cc2) (bal) (act) Want: $BOGLE | (sca)...

works like a charm, thanks fellas :)

Hey Everyone, I have a number field of a check amount excluding the decimal point. Example 50000 Check amount is actually 500.00 Is there a way to insert a decimal point before the last two numbers? This is for a mass file, so an automated process would be delightful. Got my VPs breathin...

yes you are correct, I have an autonumber, what criteria do I enter to pull only the record with the greatest autonumber

Hey, So Im trying to make a qry with some other criteria, but I need only the last record to be pulled when the qry is ran. I can't think of anything. Any help?? Much Appreciated! Thanks

Hey guys, This is probably gonna be cake for some of you, but it not workin right for me. I have this statement in a form under KeyPress What I need to to is Add another allowed Key, Backspace, Can someone help me code this? If KeyAscii < 47 Or KeyAscii > 57 Then KeyAscii = 0 Thanks!

hey guys, I set up a required field in the table properties with a Validation rule and validation text, When the field is skipped it yields an ugly error and will not let you pass the field. Where and what can I code to customize that error received? Thanks!

well i thought to just put it into 1 table because all that gets entered in is a loan number and check numbers and check amounts, time and date gets populated in there too.. so there would be almost the same type of data in the tables.. the way i had it before was date, time loan number in 1...

thanks rich, but this is actually a different issue, this will be used for searching

DB can be found here... 10 megs http://stevezaiderman.com/yaber/Payment-2.zip the report you can use is called rpt_test I removed all ODBC fields from there

yes, 1 customer and make a payment with 1 check for 2 loans, but I just put those in as 2 seperate transactions... im pretty sure the linkchild and master fields were fine, i never actually checked to see how it didn't function properly... i was told it mis matched so i changed it

im in the process of trying to host it for u guys i also thought of another method, maybe easier theres a check box on the report, maybe when value=-1 it will set the 9 fields to visible=true, any way to do that?