Search results

Hi there Some expert advice is required here guys (please) becuase I need to decide whether MS Access can do the job or do I need to move to SQL Server/MySQL! My DB runs several action queries (delete/appends) on the client's main SQL DB and then there are about one hundred reports they can...

Hi All I really hope someone can help here. I have an access 2000 db as a backend for my asp.net application. There can be up to 10 concurrent users and each user deletes and appends his records in the tables based on his username. The tables are indexed using the username. My problem is that...

Hi there When using parameters from one form to the next I normally hide the form and then reference the parameter textboxes in the next form to the hidden form. Is there a better way of doing this as I saw threads here mentioning passing a parameter. How do I do this? Thanks! Dave

I hope this is a simple query becuase my brain has drawn a blank on it. I have a query with a parameter which a form textbox. If the text box has X value I want to use one list of parameters and if has Y I want to list all rows in the query. Any help appreciated! Dave

Hi there Can someone please help me with this, I'm using the following code to update a textbox on exiting a separate textbox. Aghhhh! Private Sub user_Exit(Cancel As Integer) Dim clt As Variant clt = DLookup("client", "users", "user_id = user") Me.client.ControlSource = "clt" End Sub

Hi there I'm new to all the VBA coding and wondered the simplest way to code for the following: 1) The user inputs data to a form based on a table. Where the field is set to required I need to show a message box that says this rather than the standard MS Access error message 2) Where the...

Hi there I'm new to VBA coding and think I have a straight forward question I want to run a macro based on an if statement built in to a click procedure on a button called "Command8". Basically if username = password then run the macro, otherwise show message box "Login Failed". Thanks in...

Hi there Can anyone tell me why a make table query runs nearly 4 times quicker in MS Access than the exact same query in Enterprise Manager? The query makes a table containing about 16000 records. Thanks in advance. Davebhoy

Hi there Can anyone tell me why a make table query runs nearly 4 times quicker in MS Access than the exact same query in Enterprise Manager? The query makes a table containing about 16000 records. Thanks in advance. Davebhoy

Hi On certain machines when the user clicks a button the click command performs an openreport event procedure in print preview. Access then crashes saying it encountered errors and will close. When I change the click command to open the report by a moacro the report opens fine. I've already...

Hi On certain machines when the user clicks a button the click command performs an openreport event procedure in print preview. Access then crashes saying it encountered errors and will close. When I change the click command to open the report by a moacro the report opens fine. I've already...

Hi there I'm new to this so please be patient! I have developed an Access database which produces financial reports based on a date range which the user specifys, taking the data from a SQL server. He chooses his dates and then runs a macro which creates the new tables, overwriting previous...