Search results

Livmanto@yahoo.com

Try using the name of your textbox like me.textbox1.value

I think thats outside Access capability, more of Windows... You can just replace the existing database instead with the new one, move the old one to another place.

Control Tip Text Property? in properties?--ALL

Set up empty tables but are pre-linked... Go to tools, relationships.. Then feed those tables from your outside tables. You have to create delete all, then insert into sqls.

round = rounds it up to 2 decimal places. Now() = todays date. "d" = days so divided by 364 (or +.25) for every day in a year.. Expr1: round((DateDiff("d",[Contacts]![bday],Now())/364),2)

Union SQL all client fields plus the table where they come from: For example: Select client_name, '1996 Table' as OrigTable from Table1996 union ALL Select client_name, '1997 Table' as OrigTable from Table1997 union ALL Select client_name, '1998 Table' as OrigTable from Table1998 union ALL...

Design query, find duplicates

Change the recordset of the subform to a query instead. Design form of the form, click on the left corner box, click on record Source, create a query filtering out the zeros.

Go to the end of the book, Index, Galactic download, page 116. http://books.mcgraw-hill.com/getpage.php?page=osborne_downloads_centercontent.php&template=osborne

Create an IF then else if all then Select * From Records

Yes Paul, it occured to me that it was based on a query but you did say it was based on a table. So check your recordset, open it as a query dataset, if the navigation button below hides the new record, then your query is not updateable. you can take out the appended table and just create a...

Check the properties - Data Entry, should be yes

Is the report's recordsource based on a query? where are you putting the formula?

IS this how you did it? IIF(nz([Ship],0) <>0, nz([order], 0) -nz([ship], 0) ,nz([order],0))

If the user enters data, you have the Before Update Event/After Update event. After update, put the value of the text box in a variable, compare it in the combo box, etc. Start testing it. After Update event msgbox me.textbox.value. ------------ then create a variable Its a whole...

if both are access databases, just drag the object to the next database.

nz function.

I would guess its your network security / firewall? Check with your network admin. If its a personal computer, check your security settings.

Try exporting it to a ready made empty table where the field is set to field type "memo" or whatever your software use for text data that has more than 255 chars.