Search results

Hi I am exporting a ready-to-install Access .accdr file as a packaged solution (with developer extension). The .accdr file when opened with access runtime (no full access installed) has only very few buttons in the ribbon. I want to add a "Refresh all" button into the ribbon, is this possible?

Hello I have a textbox, to which user has to input installation date. Access form only accepts the date to be input in format YYYY-MM-DD. But when i run a search, the result shows the date in format DD.MM.YYYY I want the user to be able to input the date in format: DD.MM.YYYY I activated...

Hi I have 2 tables: USER Userid Username Cityid CITY Cityid Cityname I search all users that have city set: Select t1.userid, t1.username, t1.cityid, t2.cityid, t2.cityname FROM user as t1, city as t2 Where t1.cityid = t2.cityid Search outputs all information into a query...

Hi I need to check whether a query returns zero values. If it returns zero, program needs to go to "EXIT_CREATION". My code always ends up giving ee = 0, when it should be ee = 1. This is my code: Dim ee as integer ee = 0 Dim db As dao.Database Dim qdef As dao.QueryDef Dim strSQL As...

Hi I need to read the latest value of invoiceid from a table, into an integer called A1. Table INVOICE: invoiceid AS integer invoicename AS string I stored a query for the search. I can read/modify the query with this code: Dim db As dao.Database Dim qdef As dao.QueryDef Dim strSQL...

Hi I have table USERS USERS userid username I want to fetch information from this table, and insert it into another table called BILLING BILLING billid (auto-increment) billnote userid username I can insert the user information with this SQL: insert into billing (userid, username)...

Hi I have Users table Users table - userid - firstname - lastname I need combobox to display two values (firstname, surname) of this table. When user selects one of the values, the combobox should return the userid value. The VB code is: msgbox "userid is: " + me.combobox How...

Hi I have used ODBC connection to a .db file that is my C-drive. Now i transferred the .db file to a server. Where can i define the new location in access, so i can keep using this ODBC database connection?

Hi I found out i can't run SELECT query with DoCmd.RunSQL The problem is that i can't seem to find any help for this problem. I searched the net and examples i found are confusing. I don't understand the resultset concept at all, is that supposed to be used? Can somebody post a simple way...

I have access 2007 I create simple form that has one button. It has only one vb script that makes a msgbox appear. The button and code works fine, but after i save the access file, it stops working! Only way to get it back working is rename the file to accdb -> accdr, so it...