Recent content by flester

Have developed an Access dB for logging and reporting on support issues. The following query is used to show how many issues are raised in a specified time period. SELECT ISSUES_BY_SYSTEM_AREA.report_category, Count(*) AS instances FROM ISSUES_BY_SYSTEM_AREA GROUP BY...

How do you make both the text and the icon visible on a command button? If the 'Picture' propery is set, I can't see the text.

further question... I put this in and it works - puts the username into the textbox txtUserName.Text = Environ$("USERNAME") How would I get it to do this only for a NEW record?

Thanks! Very useful stuff, many thanks.

How do you automatically populate (a) field(s) with the current date and time when a new record is created?

How do you get Access to pick up th OS username currently logged in to the database? For example I'm logged on to the PC as FLESTER and I wnat that recorded in the dB.

Have developed a support database in Access. I need the dB to automatically pick up the username of the user logged on to the PC. Thus if I'm logged on to the PC as FLESTER, this username wil populate a database field. Any ideas?

Developing a dB to log support calls. Main form has a combobox where user's name is selected. I want to add a text box which will automatically show the user's company when name selected. Control source for Combo contains tblUsers.name I want txtCompany to automatically show tblUsers.Company...