Search results

In trying to assist another member, I created a simple setup. tblValues has one field named 'Value', which holds 3 random text records, each containing one or more strings separated by a comma and a space. Value 434534 3454534, 7888, 44fxcew, eqeew ewrqw, 5643, art4345, 32af The Function...

Not sure if this will help, but does your form have its 'LayoutForPrint' property set to Yes? BTW, forms are not really designed for printing. Consider a report instead. HTH

Like this? Take a look... http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/1980/Import-of-file-names

Not very elegant, but this works. Forget the function... SELECT tblSearchVal.SearchVal FROM tblSearchVal WHERE (((tblSearchVal.SearchVal)=IIf([Forms]![frmOverall]![optOrdrEB],0))) OR (((tblSearchVal.SearchVal)=IIf([Forms]![frmOverall]![optOrdrEB],1))) OR...

Fairly simple: Assuming a table called tblCodes, with a StudentID field and a Code field. Here is the query: SELECT tblCodes.StudentID , tblCodes.Code , Location(Left([Code],1)) AS One , Location(Mid([Code],2,1)) AS Two , Location(Mid([Code],3,1)) AS Three , Location(Mid([Code],4,1)) AS...

Not sure what exactly you want to accomplish, except to speed it up. You are running two queries that we do not see so they may be the problem. You need to declare your variables, strAdded and strUpdated [suggest you change them from string vars to int]. Suggested changes [but do not see much...

What do you mean you've removed all the "V"s???

When you setup the linked table you were prompted for a password, and it must be the correct password, or else the lnmik will not be created. You should not be promted again for a password after the tables have been properly linked.

Let me get this right... you have a query that generates the value you need to be appended to a table? If so, just create a second append query, that queries your original query for the value you need. In VBA, you could use the DLookup function to get the same value.

Try this... Assuming a table [tblCellTime] with an Employee ID [EmpID], and a cell time field [CellTime]... and that field [CellTime] is always in the format of (m)mm:ss use a query to get your totals... SELECT tblCellTime.EmpID , Sum(Left([CellTime],Len([CellTime])-3)) AS [Min] ...

Why Why do you open the query first? Just open the report.

link 'em. You will be prompted for the password.

Apparently, you have the values formated/typed as text. Try: SELECT Val([ATT1])+Val([ATT2])+Val([ATT3])+Val([ATT4]) AS ATTT FROM tblATT; :cool:

Sounds like a reference problem. Try checking the reference to DAO 3.6 object library. ;)

Suggestion: Do NOT sell it. License it to them [non-exclusive]. Why? What if [not likely, but, what if?] there is a real market for your db? Your employer would then be able to market it to the world and cash in. Take a look: http://www.greatideagear.com/software.dev.legal.gd.html

Yep. But I don't think that scenario requires a history or transaction table. Just reassign the number if you don't care who had it previously.

I do not believe SQL Server recognizes data collected from a form that resides in Access. Work around by figuring out a way [new query maybe] to provide the same data without referencing the form. The last two issues: Not sure you have a problem since it did create a stored proc for you...

Well, without knowing more, yes, that sounds right. Unless, of course, you need to maintain any sort of history or record of transactions.

Take a look here: http://support.microsoft.com/?id=148463 :cool:

If you just need to track a few fields of data, and all fields are in a one-to-one relatiosnhip, then one table would likely do it. If, however, you have one employee with many employee numbers, then setting a a proper table relatiosnhip would be more appropriate. HTH