Search results

Hi there! I hope you can help. I am not having much luck researching this. I am looking to: 1) have an Access user choose a row number that corresponds to a row on an Excel spreadsheet. I have a little pop-up form that asks the user to choose a row and a button to launch the vba. 2) transfer...

Hello All, I have an open pop-up form where I enter a date in this field: [forms]![frmTurnAroundTimeExcel]![txtWeekEnding]. I would like to use that date in my query to limit my results to the month and year that is in txtWeekEnding. So if I enter 9/13/2013, I would like all results from the...

Hello there! Thank you for taking a look at my question. I have a table, refEmployees, with a key of EmployeeID and a date field of ADM001Test. On the form where a button calls the function to add the date, the EmployeeID is set as a hidden field [Forms]![frmTrainingModule]![cboUserName] which...

Hello, and thank you for taking a look at my problem! There are four fields of relevance: [tblVeg].[Vegetable], [tblPrice].[PriceID], [tblPrice].[Price], [tblPrice].[DatePriced]. There are hundreds of different vegetables, and thousands of days that constitute the primary key [PriceID] value...

Hi there! :D Early in my Access consulting, I came across a database that had the navigation pane password protected. If you hit F11 from any form, a textbox asking for a password popped up. Really neat trick! No one knew the password, so I could not work on that database... I assume...

I'm Scott. This is my first time on a forum. I have been creating simple Access databases for a few years, and know a little VBA - learning more every day. My new job has some programming expectations that are, at times, a bit above my level; so, I welcome the help and expertise. It is a...