Search results

For my opinion Access is not the right system to handle so many records and USER. I do not have any knowledge about SQL Server only that it is the Big Brother. So what about: Database in SQL Server and build front ends by Access. This should be possible. Good luck

Hi, is it possible to set the default number at an OnOpen event of the form? Kind regards

Hi, the only way to solve this is to create a table which contains your equipment and a field like: current user which is linked to you first table. For my opinion the secon table can be removed. Kind regards

Hi Graham, I tried this myself to create a prevalue to a field. This lead to nowhere. To create leading zeroes you can use in the table definition of the field the format 000-00000 (in this case a department of a company which contain always the internal branch as "001" for example an then...

Hi, if you create a query you can decide what type of query you want. One of the types is "tablecreatequery" (sorry, might be titled with other words in an english Access version). Selecting this type of query you will be asked to put in a name for the query. If you do so, the query will create...

Hi, you can run a macro in Excel by Access but first you have to connect the Excel object library. You have to open an own instance of Excel with the workbook you need. Here you can run the Excel macro by using the Excel commands. Instead of running an macro in Excel you can do all the needed...

Hi Rob, the simpliest way is to create a parameter query. Create a query and as criterion for the author name you put in Like "*" & [Which author name do you look for] & "*" The same for title and category. You can do this in one query. If, for example the author is left blank and only quit...

Hi, another way to solve your problem: create a button on your form and connect a macro to "OnClick". In the macro you select as "action" the "OutPutTo". Here you are able to define an object type "query" and the object name "query xyz". The ouputformat you can set to Micosoft Excel (*.xls)...

Hi Dan, the alert commands in Access are part of the DoCmd command and can be used in a macro and module. Kind regards

Hi, for my opinion the only way to fix this to create your own export function by opening a new Excel object and than import the current data. This will also allow you to store the imformation in your file system at a place you want and not the one on c: drive which Excel prefers. Kind regards