Search results

I have a table with contains issue numbers and a tick box to say whether or not it has been published. I need some code that will go through the table and find the first number which is unticked to that I can use that issue number. THanks, Richard

Brilliant! Thanks so much, you're a life saver. Richard

Because this must happen each time the database is opened, even if I automated the open and delete part, it would take a while.

I urgently need a way to clear a table in a different access database, this table is not and connot be a linked table. Please help. Regards, Richard

I urgently need a way to clear a table in a different access database, this table is not and cannot be a linked table. Please help. Regards, Richard

Hello, I need to import the data from one database into another everytime a form opens, I have some code which works: Function GrabAccessTable() DoCmd.TransferDatabase transfertype:=acImport, _ databasetype:="Microsoft Access", _ databasename:="\\trigger\wwwroot$\AW@RD\AW@RDOnline.mdb"...

I've set the database to shared in tools, options, advanced so surely you can't open it in exclusive mode can you? I thought the default was shared anyway. Richard

I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to...

Hello, I have a number field in my table as well as an autonumber field. Eachtime I add a new record I need it to check the number for the last record and add one, this field would be cleared every month. Any suggestions? Thanks Richard

Hello, Could you have a look at my code and see if you notice anything wrong as it is not inputting to the database. I have used a very similar process before and it has worked. The 2 files are attached, I can't attach the database due to it's size. Thanks, Richard

The records are been input via a form, I can put a hidden textbox that finds the issue number based on the date but I still have the article number problem as I need to store them for previous issues but they must start at 1 each month so that rules out an autonumber field.

Hello, I need the code or key shortcut to get the to the last page of my report in the preview view. The reason for this is that I have some code that creates a table of contents but it has to read through all the pages to fully complete the table. Thanks Richard

the issue is worked out using a separate table, each month of each year has a preset issue number. I have created a new table column for the new number but how do I get it to enter a number each time I add a new record?

Hello, I have one main table containing most data, that table stores data which is identifies by a unique ID (currently 1-96000), there is also an issue number, I need another numbering system per issue (so you could have issue 166, record 26), any ideas?

Hello, I have a report which is grouped into subjects and usually occupies around 30 pages. I need to create an index page at the start of the report with the subject names and page numbers next to them. Is this possible and if it is how would I do it? Thanks, Richard

while a search is running, I want to disable the fields but of course it refuses to disable the last field used. I've set the focus onto a hidden textbox, it just seems a messy way of doing it.

It need to find out how to lose the focus on a dropdown list? Without shifting the focus to another field.

I have a drop down list on the main form, I want to click the button next to that which would open a new form and have completed a drop down list (same source) with what was just selected.

I have a search button which I press after entering text in a text field or selecting something from a dropdown list, unfortunately after having typed something in the textbox, it takes 2 clicks to press the button.

I have a sql to search through a table but I need to count the number of records after the filter has been run. The database is too large to attach but here is the sql search code (that works fine): Private Sub DoFilter() Dim stSQL As String 'construct sql string based on the search...