Search results

Brian, Sorry for the confusion, but yes, that was exactly what I was looking for. Funny thing... I was close to the "Yourdate-weekday(yourdate,1)+1". I just didn't have the (yourdate,1)... Thanks a bunch, much appreciated. :)

Hi, It's been a while since I've been here. I'm having a brainfart and need some help... I have a table with a list of dates that pertain to other data in the table. In a query, I'd like to create a new column with a "Week-Of" date, with Sunday as the start of the week. I've scoured the...

Tried that from an earlier post and didn't work. I am using MS A. 2007. Thanks

I have assumed responsibility of a database created by an ex-employee. The problem is that this individual has locked the use of "Access Options", Viewing Toolbars, and the ability of editing anything within the database. Is there a way to correct this in the event there is an issue that may...

I would be pulling data from the tables off the SQL Server to show in a form on the amount of product an Employee has produced between a given time period. An now, I am not looking to edit the data, but extracting data for viewing purposes only. I already have one query I was able to build...

OK, I am tapping in the SQL Server database from within Access. I am trying to create a query from a query statement that works fine on the SQL Server side. When I applied the same query in Access, it doesn't work and end up getting an error code (Syntax error in FROM clause). And to be...

Anyone? :)

OK, this may be a stretch and hopefully someone can help me out. I am looking to put together a chart that is able to change the date output format. In other words, instead of having a different form for each date type (ie. By Week, Month, or year) I want to be able to put the date range...

OK, perhaps I wasn't as clear as I should have been. Right now, we are storing data by date {Field Format Type: short Date} (ex: 1/29/2009, 1/30/2009, ect, ect, ect....). In the form, I want to perform a search, but not by {sort date} to {short date} (that's easy to perform), rather I want to...

hmmm, not what I was expecting. How do I implement this? Thanks

I am trying to select the month and year from a combo box on a form taken from the tlbData table, which the field is formated with {short date} containing daily entries (ie: 1/29/2009, 1/30/2009, and so on). I am working on retrieving data that fits within the Month's search criteria. Can...

John, Great job and thanks. I had to remove the code from OnCurrent on the frmDatAEntry form because it was interfering with a "GoTo" new "Record" macro On Open I added to it and it seems to be working fine without it. You wouldn't foresee any issue with that in the future, do you? The good...

Sure John, When I use the two nav buttons to nav through the WO's (not the dates) I had put on the form, I can see within the "Fabric Re-Cut Data" area, the two fields (Materials Series and Fabric Color) do not refresh. :rolleyes:

OK, I've tried various ways to implement your suggestion and still nothing happens. I have attached a shorter version of my db and was wondering if you could take a peek at it. This is one aspect that really needs to be cleared up. Thanks again! :D

John, Thanks for the reply. How would I requery my combo boxes. I think I'd want to use the =RequeryControl() command, but there is no OnCurrent box in Properties for either combo box (note .jpg attachment). Could there be another way? Thanks. :confused:

I am using the requery function to filter two combo boxes in two different subforms from the main form when selecting material and color depending on department. I am having no issues with performing that task. The problem I am having is if I shut it down or goto Next record, those fields are...

OK, got it to work. Consider this to be resolved. Thanks Bob.

OK, just for kicks, I closed down the db, opened it back up and tried to run it again in hopes of refreshing my system's memory. Now, the error I get is this: "Run-time Error'438': Object doesn't support this property or method" Any ideas? Thanks again,

ooookay, thanks for your random input. :confused: Bob, actually the error code is the same, but it's now referring to sfrmDataEntry1, the form in which the Department combo box is located. :cool:

First may I say, thanks for replying to my post, especially in a timely manor. I've seem a lot and come to admire your work. Thank you for of your contributions to this forum. OK, I tried that and still get the same error. sFabricEntry = "SELECT [tblMaterialSeries].[materialserie_Id]...