Search results for query: *

Thanks Guys the problem was not the code. I changed the data type fro text to numbers and works very well now thanks for all responded

Hello all I have the following question using Ms access 2010 I have two text boxes where depending on what is entered on the first the 2nd disabled. that works fine but if I make a mistake and enters a value on the 2nd while it is was enabled and return back to the first and enters a value...

Hi all I wonder if there is a way to modify some of the disabled toolbars of a report after the database is packaged & installed in computers something like a service pack without affecting data already entered Thank you in advance

Thanks. Is there a point of spliting if you are installing your database into stand alone computers after packaging it?

Thanks Dhookom That makes it work. Thanks

Once you packaged your Db and installed it in computers can you see the database somwhere else. The reason is I want to make sure the database is backedup frequently. any suggestoin is appreciated bb

Once you packaged your Db and installed it in computers can you see the database somwhere else. The reason is I want to make sure the database is backedup frequently. any suggestoin is appreciated bb

Hello all I would like to know how to show in a report a graph which is based on a parameter query (i am using Radar chart). The parameter dialog box is working fine but the graph is not showing I have set both the RowSource property of the graph and the RecordSource property of the report to...

Thank u for Ur time dhookon ? [forms]![digBox]![text0] Gave me the value I expected but ? [forms]![digBox]![text2] return Null in debug window text 2 was supposed to pass a date value(Medium Date). I pick the date from date picker. Thanks again

1st I open the form, then when I go to the query the form stays behind Now using my own SQL or the SQL statement you provided above I press the exclamation mark to run the query. At this point the "digBox" does not come at all. It Just show me the result in dataSheet view (which is empty)...

There is no code that opens the form but the Query is a recordSource of a report which will be generated based on the criteria.

dhooKoom My answer to both of Ur questions is Yes I Open the form prior and while opening the query, and also I replaces the two references with values of "OVCId" and "DatesProvided" and in this case I receive the result. Not only that i can also use the default Access parameter entry dialog...

Well Open the form it is the same the SQL is as follows SELECT ServicesProvided.ServiceID, ServicesProvided.ServiceType, ServicesProvided.OVCId, ServicesProvided.CGId, ServicesProvided.DateProvided, ServicesProvided.ComponentId, ServicesProvided.Others FROM ServicesProvided WHERE...

If you mean to run the "digBox" the customized form. Well I did run and when I run the query after that nothing comes and the query result comes with nothing. any reason why? Thanks again

Hello All I am trying to use a customized Parameter query Dialog box In access query. I created the dialog box [digBox] using a form and I have the following in the criteria raw of my query [FORMS]![digBox]![TEXT0] but the problem is that instead of the custom dialog "digbox" form the default...

The Security feature of 2007 which disables VBA, and Macros was ON. Now I disable that and Now it working perfectly well in both 2003, and 2007. Thanks

Sorry for coming back again dhookom You know this thing works perfect in Access 2003 and enters all 100 records, but after a while when I test it using Access 2007 it is inserting only one record and even with that record the [stid] value is not inserted. any idea about this. Thanks in Advance

Now it works fine Thank u very much dhookom

Now I started clean and received a message "Number of query values and destination fields are not the same" messages. any Idea ??/

Hello dHookom Yes I tried it using Private Sub Command15_Click() Dim strSQL As String strSQL = "INSERT INTO table2(stId, serviceType) " & _ "Select stId from table1" & "' Me.txtServiceType'" DoCmd.RunSQL strSQL End sub But when I click the button nothing happens...