Recent content by turtlpc

It's the record count we're looking for on returned rows in a query. Internally access maintains a record count, but how can we access it for use? We would like to create query that searches a couple of tables and returns x number of rows, from which I would use the record count to select a...

Unfortunately the Auto Numbering will not do as the 'auto' record number is deleted along with a record deletion. Thereby not providing an accurate record count, which is what I'm looking for. Thanks for your efforts Phill

I have a form with x number of fields displaying library type of information. The user searches the app for customer number and is returned a record displaying the file address via a textbox. The files are in a PDF format and are located on numerous CD's. I can make the file addess a hyperlink...

I know ACCESS has an internal record number, but I am unable to figure out how I can access it for use in a query. What I would like to do is create query that searches a couple of tables and returns x number of rows, from which I would use a record number to select a specified record(row). Thanks

I have a query, that searches a table based on the parameters I provide. This was pretty simple using the criteria in the query design (SELECT [File Directory].CDnumber, [File Directory].Doc_Number, [File Directory].Doc_Type, [File Directory].[Document Date], [File Directory].Customer, [File...

If you're looking at keeping the data, changing only the data type, I've found that a method that works well is to copy the table(structure only). Then paste and give the new table a temp name. Then change the datatype of your fields. Then create an append query to copy the data from the...