Search results

instead of export the report to excel, would you prefer to export just the data, so export the query that is attached to the report.. Hope this helps.

try txtsubtotal.requery let me know if this works. This is what i would do i am normal access database. I have not used the adp form etc

are the refreshing the form or just the field??? if you can paste your code that you are using to recalc the field that would be good. Also the name of the field and the name of the form

you could do this one of 2 ways. Instead of importing the csv file each time it change, you could link the file to access. Then just overwrite the file on your network with the most up-to-date version, then anybody can do this. But the second version I would do is to link to a csv file, the...

what you want to do if you are getting into access use the wizards to help you then look at what they are doing, so you then are able to alter it better to suit your needs. I not be funny, but the best way to learn... Use the wizard in the form, and run a query from a command button If you...

quite simple, use something like the following, if you post your table name and field name you want to query then i could write it for you. SELECT field1.table1 FROM table1 WHERE (((field1.table1) Like "*" & [forms]![form1]![txtfield1] & "*")); This will look for a value in the form and...

are you taking the value to be able to query on this value against a field within the table???

you could probably use a simply form with a timer control, and set it to run at 7. How do you run the sync, through code, or some other program??

you need to link the list box to the combo box by a certain field. So a field that is in both sets of tables. Lets say this is "FIELD1". In the combo box you need to know where this field is displayed, and have this field bound to the combo box. The reason for this when you relate the list...

I have a way of changing what database i am looking at within a SQL server. The issue that i am having is that everytime i load up the access file it keep on asking me for a username / password. Is there anyway of stopping it doing this. When i have done the original link, i asked it to save...

What i am trying to do is change the sql database that the access file is linked to. I have done this before using dbase file, but i am unsure how to re-link to an sql server. I have a path of the database of:- MSSQL: DB_NAME: dbo: I have a file that is linked to access file that gives me...

Give this a try In your field that you want to validate the entry, in the after update procedure type this If RemoveAlphas(FIELD_NAME) = "Yes" Then 'email is ok Else MsgBox "Incorrect email address please enter a valid one" 'email does not contain the @ symbol End If Now create a...

You would need to create a list box to display the information, within the properties select query that you create. Depending on how you run the make table query then you could use this way of updating the value in the list box. If you run it through a simple command button then just add the...

seems quite straight forward. you have the table that has all this information... Create a query that display all the standby information, then create a query thats display all the callin information. Use the unmatched Query Wizard, select the standby query first, then the callin query, match...

it depends on if the central database is to store the data or to add additional data as well!!! You have caused yourself a lot a work whatever route you decide to take. This is what i would do. Each copy of the database needs a unique reference, so you know which copy it has come from. The...

So i take it one table should be enough. Its quite easy to use default value in access, and your would be date(), for todays date, and if you wanted yesterdays date then it would be date()-1. When you say "minus a day for them", a bit unsure why you would want to do this, but i'm sure you have...

what are you running from the module. Why don't you set the module to run when the form is opened, and then at the end of the code, close the form. If you could paste the module code etc that may help...

I do not believe so. What would happen if you had more then 2 appointments. Surely you would want to see all of them!!! You could use Crystal report, which has a drill down option, so on the report you have a hyperlink which lets you open up a different report etc. But if you are using...

I think you could use 1 of two methods here. 1st - A select case 2nd - if the field is a combo box, pulling information from a table, and you had the table as follows: - ID No Name Colour 1 Carrot Orange 2 Bean Green When the user selects the Name...

have you thought about using a IIF statement.