Search results

:) 4 tables with different fields (4-4-7-25) and 40 000 records. Table Analyzer Wizard give me msg: "You can put at most 15fields in a lookup table" :(

i try with querie...unsuccessfully :( I'll try another atempt - with "Tools->analize->table"...What will happend..i'll see :)

I have one table - 40 fields, 40000 records. Iwant split this one table up to 4 different tables (keep data). Is there an easy way, pls?

;) ;) ;) ;) ;)

Open form in "Design view" ->click on "Delivery number" with right button -> then selsect "change to" -> "combo box"

field properties->input mask-> "????????????????" for letter Aa-Zz entry optional or field properties->input mask-> "LLLLLLL" for letter Aa-Zz entry mandatory

Im not sure if I ubderstand right...but where is prob? =IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"X",""))))...drag down..

Shane, I talk about NEW record..If there are so many records...I think I use a list box(combo box) is not good :( I'm not sure that I'm right...

Hi all, I have a table with examp. fields: T_nom,T_name,T_code,T_phone..... I have a form, based this table. I'd like to be able to enter T_code into my form and if it exists then T_name fill automatically on the form and skip to the next part of the form without prompting. If not – then...

"...when converting tot text using cstr, how to change the format? (or is this then only possible by changing the windows settings?)"...Change it by win settings (with date separator what u want) & use ctrs, then ... i try do all these & export in rtf is oki

I cannot understand what u want to do?!?!? Where is the prob?!?!? It is just a table :) Resize column (with dd/mm/yyyy) :)

for cells: Format-> Conditional formatting... for column Counter -> use function count... at last sort by column Counter (descending) I think it is easy ...not unique :)

like this? (but without macro :( )

I try it... there is a prob with "so many fields" in "Layout=tabular". If u choice "columnar" or "justified" - ok. this is not explanation, a part. decision ;)

http://support.microsoft.com/kb/257452

Hi :) more than 255 fields?!?!? Who will understand that report? Are u sure that all needed?

See: Form(Design view) -> Proeperties -> Data -> DataEntry = NO

increase "column count" to 5 (exmp)

I find this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2245820&SiteID=1

Hi all, I make a table "CATGRY" with 3 col: CATGRName, CATGRPic, CATGRDescrip For field CATGRName i set "Indexed =Yes(No Duplicate)" in the table. Then make form, based on this table.... When I input duplicate CATGRName I want receive my msg "DUBL DUBL", clear box and input new name again. What...