Search results

ok, I just discovered another small problem. For some reason the first part of my code doesn't work... If me!group_ID = Null Then me!group_ID = Null It isn't recognizing if the field is blank, and just tries to go to the if me!group_ID = [issue details] part, and then gives an error because...

Bob...you are a VBA GOD! Thanks, that worked like a charm!

I am trying to update a date/time field in a subform, and when I get to the line in the code telling it to set end_date = Now(), I get Run Time Error 2448: You can't assign a value to this object. If Me!group_ID = Null Then Me!group_ID = Null Else If Me!group_ID = Forms![Issue...

Thanks so much for the help! I REALLY appreciate it!

The way I was previously pulling was using datediff to get anything between today and 6 days ago, so what is the difference between running it as a datediff and from the form?

Ok, I set both queries to pull their param from [Forms]![frmDateRange]![startdate] And [enddate], and it is working...except for one tiny problem. :-) The main query used to group so each instance of ID was returned once...and now it is returning for each time a comment was made... SELECT...

ok, I apologize if I am being a bit dense... I'm looking at your sample DB, and the query you have running the form does not have any parameters set in it, all your parameters are set by the docmd.openreport command, correct? The report I'm working with has a query with the parameters set as...

The report I have created has a record source as a query, and then there is a sub report based on another query. Should I remove the query as the record source, and just put the DoCmd.OpenReport command on the button? If so, how do I still pass that to the sub report as well? Thanks for...

Not sure if I am posting this in the right place... I have a form frmDateRange that has 2 text boxes, startdate and enddate that have afterupdate events attached to them. The only thing that happens is startdate and enddate are put into variables. What I would like to do is pass those...

the form itself is tied to the Issues table, so wouldn't me!ID = Issues ID, instead of the tblwithgroup.ID?

Either lunch, or beer. I will need to strip it down and remove some information, but sure, I can put it up here.

I want it to find the record where Issues.Group_ID = tblWithGroup.ID... (and this is why I get so confused when trying to learn programming!)

I'm trying to get it to pull the group_ID field from the Issues table...and was thinking like a SQL statement...

Thanks! I got the message box to pop up, but the groupID apparently doesn't have anything in it (I get "the group ID = .) ...which is why the rest of my code doesn't work! :) Now to figure out where else I screwed up! Thanks again, you guys are awesome!

I am relatively new to databases, and brand new to programming in general. My background is mostly in hardware, networking, and security but I am looking to expand into VBA and databases. Can anyone recommend a good book that will help me get started understanding not only how to program in...

I'm trying to debug some code, and see what is getting returned from a dlookup search, so I tried to put a MsgBox in that would display the dlookup result. Dim groupID As Variant groupID = (DLookup("ID", "tblWithGroup", "issues.group_ID = " & [ID])) MsgBox("check me",vbOKOnly, "Check...

I'd like to know if it is possible to add a new record, and then take the ID (PK) of the new record, and have it stored as a variable for use in a different area. So, if I do: Private Sub form_AfterUpdate() Set rs = CurrentDb.OpenRecordset("tblWithGroup") .AddNew !Issue_ID = me.ID...

Excellent! That worked! Thanks!

Where should I put it if not in the On Focus part? On form load? And how would I destroy it, or does it go away when the form is closed? Thanks!

Yes, I put the stop in to see if it was actually doing anything, and it appears to...though it skips the DIM OldGroup As String part.