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

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 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

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

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

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...

I have a database which is open most of the day, I have on online input form which input to the access database but this fails when the database is open and even if I use a second linked database. I need ideas to get around this? Thanks, Richard

Any ideas why this code isn't working? Private Sub cmdClear_Click() 'cancel the filter and clear all the search criteria objects FilterOn = False qtitle = Null qauthor = Null qissue = Null qjournal = Null qsubject = Null qsubject2 = Null End Sub It's from an already...

Hello, I am trying to put in and add button to my form so it saves everything into the table, here is my code: Private Sub Add_Click() Dim db As Database Dim rsWrk As Recordset Set db = DBEngine(0)(0) Set rsWrk = db.OpenRecordset("Table", DB_OPEN_DYNASET)...

I need the code that will tick the box in all records in a table Thanks, Richard

I need a system which will tick all the boxes to corresponding records when I print a report? The next time I open the report it would only show the unticked boxes which had yet to be printed. Thanks for your help, Richard