Search results for query: *

I think this is an easy question for all experts her on the Access forum. Can I count the number of rows in a db? - Tom

If I want to run a sql query from a dropdown list that says a number, in this case a employee id, and I want the result to show in a textbox. How do I implement it? I have the the sql query (Is a SUM query so itr only return one answer) ready but I dont know how to return the value to show up...

Hello, Is it possible to remove the "loading image window" in a form when the JPG file is loading? - Tom

In C++ you can store values in an array like: str[3] = hello; Can I do the same thing in Access? I want to store a customer number and later generate a report. - Tom

Hello all, How do I create a query at runtime and open a form with the result. Example the SQL statement "SELECT Name FROM Persons" open a form frmPersons and show all the names. (The textfield that contain the name can be static in the form). - Tom

Hello all, please help me with this one. Whats wrong with this IIF. (Form!F_Order.payment is a checkbox, [sum] is av value from database) =IIF((Form!F_Order.payment),([sum]/3),4000) This is placed in the controlsource of a textfield. - Tom

How do I generate three pages in a report instead of just one?. I want to change a value in each page. - Tom

I know how I get the value from a combobox: getText = Forms!Formname!comboName.Value But how do i get the value (state) from a option button? option = Forms!Formname!optionName.Value?? - Tom

Is that a function that returns the path to the dirctory that I run my access application in? - Tom

Hello, I have a report that contains a subform. In the subforms onOpen I have said that if a checkbox is set to true then the forecolor should be green, that works great if you just open that subform. But if you open the report it doesn't read the onOpen event, the texts forecolor doesn´t...

Hello, lots of questions today. I have a checkbox in a form. The form also contains a button that generates a report. The report contain a subform that has a textbox called Price. How do I change the color of the text, Am I on the right way?? (chkColor is a checkbox) On the On open event in...

Hello my problem is that i have a database with two tables and I want to read the information into textfields in a form. The tables is of the following form: 10 rows with four columns and I have 10 x 4 textfields named col1, col2... How do I get the information into the textfield in an easy way...

Hello I have an image in the top lefcorner of my report. In a "settings" table I have a column that contain a path to an alternative image. THIS IS THE CODE THAT SHOWS THE IMAGE: --------------------------------------- Dim strGetPath strGetPath = DLookup("path&quot...

Hello How do I get a value from another table. Example if I have a table mapped to a form then I can just write: Dim test = [column] But if the column is in another table, how do I do?, or can I mapped more than one table to one form?? - Tom

Hello all. Isn´t there an EASY way to locate a file and return a path as a string?. I want to have a button that opens a window for browseing a picture (jpg) file and the return the path. - Tom

Hello all! I have a form with a checkbox and a printpreview button. How can I in the printpreview (when I have pressed the button) the value of the checkbox and the diside if a textfield should be shown or not. - Tom

Hello I have a problem. I want to update my control for my subform with a new subform. This is really hard to explain but I hope someone understand. To update I use a radio button that runs a Basic code on focus like Private Sub radio1_GotFocus() Me.F_Subform1.SourceObject = ???? End Sub...

Hello I have a question (again). I have a dropdownlist which gets information from a table. The information is an ID and a Name (I have hidden the key in the list so the only thing that shows is the name). The dropdownlist have a name (ddl_Names) and when I run a SQL query like: INSERT INTO...

In my application I have a button that executes a Macro that runs a SQL query. The SQL query is an insert and generate a message in Access that says "Acces is about to insert records..." or somthing similiar. I have a swedish version so I don´t know if that is the correct words. How do...

Hi all Can I in a private sub in VB update a value in a table?. Like: row1,col2 in DB = Me.product1 I don´t want to use SQL because that are very many records that should be updated.