Search results

It's on my machine at work - let me have a go on Monday and if need be i'll attach a screen dump. Have a good weekend and thanks again for the help!

Hi again Yes i'm sure your suggestion would work no problem, i'm not rubbishing it by any means - it's just not really a feasible option for me due to the cosmetics of the db. I seem to remember using Access 2000 I could disable the menus et al and still have close buttons on the top right of...

Hi Yes there is a button on the form to close, but if there are no records then the form is completely blank, i.e. no buttons or anything. Is there not a way to check if the table is empty and if not display the button?

Hi I'm not opening a table, the records are browsed in a form, but because i've locked down all the menu's, ribbon etc there is no option to close the form

Hi Does anyone know how to hide a switchboard button so it's only displayed if the table has records? I've hidden the ribbon etc from users but the issue is if they click on "browse records" and the table behind the form is empty, the only way back to switchboard is to close the db Thanks in...

Hi mate Worked a treat - although I did have to re-write a couple of queries to get the data pulled from the local temp table instead of the back end table Thanks a lot for your help. WR

Ok great, that makes perfect sense! I'll make a couple of backups before I try this tonight and I will let you know how I get on. Thanks a lot for your help! WR

Hi again, sorry - if my understanding is correct, the BE would house the tables and data and the FE would hold all the forms, queries etc? if this is correct, i'm not sure if this does solve my issue: When the user clicks the save button, I have an append query which stores the current...

Hi there Thanks for the reply. No, I haven't split the db - never attempted that before. Do you think this will solve my problem? If so, can you recommend any good tutorials to do this? and also, does this require something to be installed on the users local machines? Thanks again

Hi all I have multiple users across a network using a db and as a solution to a problem i've faced, I am trying to do the following. If a user saves a new record, I would like access to check if tempTable exists, if it does then check for tempTable1, then tempTable2 and so on. When it...

Hi guys Final stage of my project and i'm stuck! With office 2000, it was possible to Print# to HTML but this doesn't seem to be possible with 2007 I have an XML file, which pulls data into fields and uses and HTML template to style the page. Is there a way to get the complete xml document...

Hi all Thanks to you both for your help. I finally wrote a query for the save button which writes the current record to a holding table. Then another query so that after the data is pulled from the holding table, the contents of the holding table are deleted. Bit of a work around, but it...

HI using "SELECT * FROM Q_email where strOut = '" & Forms![tbl_faults].[raised_by] & "'" does nothing... still pulling all details and not just the current record

yes, tried that when you sent it and got that error message

Hi Thanks for the quick reply - im getting the error "cant find the form 'tbl_faults' referred to in a macro expression or visual basic code

All I have written code, which places data into an XML file, using an HTML template for styling: Public Sub generatexml3() ' declare variables Dim rs As DAO.Recordset Dim strSQL As String Dim strOut As String Dim strOuts As String Dim fs As Object Dim xmlFile As Object 'create and execute the...

Hi all I hope someone can offer a solution to this: I currently have a workbook, which has several sheets, each one pulling a seperate report using a web query. This was created recently using a previous weeks reports, but having come in this morning ive discovered that the URLs seem to...

Hi all Does anyone know, is it possible to do a web query in access? Or do I have to pull the data into a spreadsheet and then link the sheets to access tables? Thanks in advance, WR

Hi Is this something I need to write in VBA? Or is it a setting? WR

Hi there I hope someone can help. I have a web query in an excel spreadsheet, which refreshes every 2 minutes. Does anyone know how to automate a macro, so that it runs when the web query has refreshed? Thanks a lot, WR