Recent content by Aspire

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

Field: Format([FieldName], "mmyy") Show: Untick Criteria: Format([forms]![frmturnaroundtimeexcel]![txtweekending], "mmyy") This is it! You've done it, and now I've got it! Thank you vbaInet!

Hi Spike, That is a clever idea, thank you; but, unfortunately in my case the date isn't fixed. They enter a date in a separate form, and it is from that form that I need to pull the date and enter into the query criteria. Using Month([..]![..]![..]) or as a DatePart returned null values. I...

Hi Uncle, I had no problems with the original post or need to refresh, post twice, etc. It let me know that the question would not be visible until moderated. Perhaps in the moderation process there is a sticking point.

Thank you, Uncle Gizmo. I will try to fit your code in with my query and let everyone know how it goes. I truly appreciate your time and skill. Off topic, I could not find any way to respond to private messages on this forum.

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

Thank you for that example. I saw something like it online, but didn't make sense the way your posting does. I will try using this framework. Thanks again!

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

Thank you for that. I'd never used it. While it didn't give me exactly what I was looking for, it did find about a dozen orphaned records. I will work with it some more using different variations and see if I can get what I need. Thanks again!

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