Recent content by mauni

I was able to find easier solution: Open the file first in accdb mode in access. Then: 1) click "customize quick access toolbar" 2) select from right drop down menu -> For : <yourdatabasefilename> 3) select items you want, for example "refresh all" 4) these items now appear in top...

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?

I was able to succed with code: <MyString> = Format(<textbox>, "yyyy-mm-dd")

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...

STOP THE PRESS I was able to find solution. I only have to update the USER table, not CITY table. This means only the field USER -> CITYID must be in the result view.

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 run lots of SELECT statements, which can't be run with docmd.runsql. I am a beginner, and i don't know other way to run them. The select statements need to be modified on the fly, depending on what user inputs on the forms, so i have to call up the saved query and modify it...

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...

DCrake your code works. Thanks all

Thanks DennisK, that code works. I was able to output the correct value also with: SELECT TOP 1 invoiceid FROM invoice ORDER BY invoiceid DESC; But how can i transfer the value into an integer? Now it only opens the result into an openquery window.

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...

HiThe tables are more complex in real life, than in my example. I just needed to get the SQL syntax, which you have now provided. Thanks.

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)...

Thanks, this made it perfect!

It only outputs firstname with that code. I need it to output the userid. How should i configure the combobox to output the userid value?