Search results

Bill, Won't that include all the ones that started and finished before the start of the current week? And what about the ones that started during the current week, but not yet finished?

Connolly, Off the top of my head, I am pretty sure this takes care of all eventualities: (Date()-Weekday(Date())+1 Between [StartDate] And [StartDate]+[Duration]) Or (Date()-Weekday(Date())+7 Between [StartDate] And [StartDate]+[Duration]) Or ([StartDate] Between (Date()-Weekday(Date())+1)...

I am pretty sure you can also do it more simply like this: rstMyRecordset(VariableName)

Cullihall, Where you say "VB", are you referring here to VBA? If so, check out the Eval() function. And also have a look at the Application.Run method.

Karyn, I don't understand what you mean by "dependent" in this context. Could you give some real-world examples of actual products to illustrate what this dependency is all about, and explain what the behaviour needs to be? Thanks.

Emily, I believe the problem is with this bit: [Form]![UserId] If the UserId control is on the same form that your macro is running on, then it should be: ..."security id =" & [UserId]) If the UserId control is on another form, then it should be: ..."security id =" &...

Agreed. I can't imagine any database scenario where this would be applicable. So it would be good to put into context by explaining the purpose you are trying to achieve.

Toeying, Regarding the date field with the current date, just set the Default Value property of the field to: Date() Now, regarding your ContactID, there are a number of ideas we could explore here. But the obvious one is the "HS". If all of the ContactIDs start with HS, then there is no...

Stephen, First point is to change the name of the Count field. "Count" is a Reserved Word (i.e. has a special meaning) in Access, and as such should not be used as the name of a field or control. The SQL view of the query you need is: SELECT BoxNo, Sum([Count]) AS HowMany FROM...

Rohnds, Yes, there is no problem with having a subform linked to a main form on more than one field. You simply type the names of the fields in the subform's Link Master Fields and Link Child Fields properties, separated by a semi-colon, for example: Make;Model However, in this case you...

Alaa, No, the COA Entry table does not need all that information repeated in it. All it needs is the field (Account Number?) that identifies each COA Active record. If you know that value, then you automatically know the value of all the related fields, as that can be retrieved from the COA...

Alaa, This appears to be almost identical to another post from you with a different subject title.

Alaa, The concept in Access would be that a properly designed database would not have these same fields Account number, Description, Status and Code in more than one table. This is a recipe for some serious headaches. You hafven't really given us enough information, and "table number 1" and...

Abdulkawi, Yes. No problem. It is very easy to get the totals to be in the subform like shown on the image on your first post. Bill and I have both already explained this. Change the subform from a datasheeet view to a continuous forms view. Put unbound textboxes in the Footer section of...

Abdulkawi, I agree with Bill. Use a Continuous View form rather than a datasheet. If you really like the look of a datasheet, you can format a continuous form to look almost the same if you like.

Bart, It wasn't 100% clear from your question whether you meant to show the number of records (which is what Linq's solution will do), or the total value of a particular field. If the latter, use: =DSum("[NameOfYourField]","NameOfYOurQuery") Or, if your query already is a Totals Query that...

Aman, Unless I'm missing something here, I think I agree with your employer. If you're not using Oracle in your job, then your employee doesn't need to provide you with Oracle training. Is Oracle used elsewhere within the company, and you are looking to move to another type of work?

Yes, I see. Thanks Chris, very interesting. And in addition, it looks like your clairvoyant instinct was firing on target, which is a bonus. ;)

vbaInet, Yep, ok. Did that. Behaves the same in Access 2007.

Linq, Please have a look at the attached, and let me know what I have misunderstood.