Ranman256's latest activity
-
Ranman256 replied to the thread Visablity of feilds on continuious forum.in continuous form ALL boxes on EVERY RECORD w that name are visible (or not) at the same time. you cant have 1 line visible and the... -
Ranman256 replied to the thread Update Query.too many SET commands. (only 1 needed per query) dont use sql code, use queries. they never get syntax wrong.
-
Ranman256 replied to the thread Solved Access - INSERT INTO w/ strPath.link the table as an external tbl run append query.
-
Ranman256 replied to the thread Date string to Date.I always LINK my xl sheets as external linked tables. then to import , run an append query, The query can convert the field...
-
Ranman256 replied to the thread Create a new table on SQL server from a form with VBA.No. You must alter in SQL manager.
-
Ranman256 replied to the thread Shell not displaying.Running shell event does not keep a cmd window open. It just executes the command.
-
Ranman256 replied to the thread Move down row od text.you dont extract data by cycling thru form rows, extract it in bulk, (to excel) via Transferspreadsheet.... (you didnt say how to...
-
Ranman256 replied to the thread Compare number of columns in Imported table from CSV with target table if are the same.See if the col. Count matches... Currentdb.tabledefs("table1").fields.count = Currentdb.tabledefs("table2").fields.count
-
Ranman256 replied to the thread Exporting a table field as a separate standalone row (better explained with pictures!).Remove shipping col. From the export query.
-
Ranman256 replied to the thread Solved Colour code data entry row.in continuous form, all rows must be the same color OR alternating colors (altcolor) a,b,a,b NOT all rows 1 color, except entry row.
-
Ranman256 replied to the thread Find all records ignoring time.Make a base query that converts the field to pure date: DteFld Format(field,"mm/dd/yyyy") THEN do your date range in that.
-
Ranman256 replied to the thread Auto fill text boxes using SELECT query.make a form that shows all data from a table. (usu a continuous form) then put the 2 text boxes in the form header. when user fills in...
-
Ranman256 replied to the thread SameFE, Same BE, one a qurey user works fine, another gets "data type mismatch in criteria expression".what about 64bit vs 32bit? both the same? what about office versions?