Hi everyone,
I would like to know if VBA is able to track user activity on the computer?
Things like Idle time (similar to "away" or "Idle" in MSN), or to know if outlook, e...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hello,
I'm trying to build a hotel automation application and got stuck with the the reservation part as follows: there are two combo boxes in a form followed by a code to determine the price from...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
i try to import data from multiple excel files into a table. I'm using the following code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tabel1", "d:\acc...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All,
I built a datasheet form based on query. This form is a sub form in another form and should present resaults for searching. for make it dynamic I change the SQL in the Qeury it based on....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is it possible to jump directly to a record simply by using row number and column name?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am using this code to write to an .xlsx file and when it opens it opens in ReaD Only. Can some one give me a cure for this?
Code:
Function ExportToExcel()
Dim objXL As Object
Dim xlWB As ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
While brawsing this forum i came across an advice by someone regarding switching between 2 system.mdw files in order to import objects across two different database with each relying on different ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi There,
I'm a total noob. I'm building a very simple "Time Track" program in Access 2007 for my company. However, I'm looking to filter a report that I want to generate. What I want ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to hide and unhide to dramatically reduce the loading time of my app. I do want to have the users task bar occupied when the program is minimized (I want them to think the program is ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I have a question and i am hoping you guys could help me with it.
During an event procedure, I would like to pause that event untill a certain condition has been met. More specifically, after...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
Under Windows explorer, when I right click on a file, I want that my Access application (which is in a contectual menu) once loaded, give me the path of the file. How can I do ?
Any idea ?...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am not getting what I need with this function. It sends the data to Excel OK but I need the Excel file to retain the macros set into it and this function seems to make a new workbook each time. ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am new to programming and Access. I have been reding all over and still am failing at this. I have an Excell spreadsheet that I import into Access. This will happen multiple times each month. W...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am attempting to create a function that will convert a record id in a query to display a hyper link value.
Not sure if this can be done. What would be the correct syntax to change the RecId in...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
On the Formula page in the scientific section of the application that I support there is a main form that describes each formula, and a sub form that lists the ingredients required for each formul...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello Everyone!
I would like to display a message box to a user that is attached to an button in a form that would have a yes or no answer. If yes, I want to capture the Timestamp and the conten...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have written some code to alter the format of a text box when a specific date range is found in the Dlookup. Please bear with me I am relatively inexperienced in VBA!
Private Sub Command590_Clic...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
grateful for some assistance:-
Problem:
I have a database with a lot of records. The first task that i would like to carry out on a daily basis would be to check how many records have ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Greetings Access Colleagues:
The code snippet below fails with the error, 'Run-time error 13: Type mismatch'. I have perused many sites and forums during the past few hours but without securin...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Have the following bit of code which opens an Excel file related to an entry in a form when the user clicks a button:
Private Sub Cmd_OpenExcel_CoreLoc_Click()
Dim CorePath
CorePath = "W:\Cor...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to write a function which calculates the stableford score for a golfers round. Unfortunately, I am quite new to access and my coding experience is with Progress Open Edge.
I have atta...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, please see my attached database. rename to rar
I have table tbl_items where I enter items and another table tbl_poppular for popular entries I would like to be able to click a button see t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All,
I am looking to create a form that will open different database on a shared drive...but I keep getting this error:
"Microsoft Office Can't open because its missing or opened exclus...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to filter a form using variable input from the user. I simply want the user to be able to input his/her name and the form will filter only records that apply to him/her. I'm assuming the ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have some code that runs some code to add a foreign key to a sub-sub-form. To refresh the foreign key data I also run a requery. The code also saves the record. The sub-sub-form is now reset bac...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
