Recent content by NeedsHelp101

Ok, so here's my code: strSQL = "Update tblMasterNames Set FirstUse =#" & Format(Me.boxWeekBegins.Value, "yyyy/mm/dd") & "# Where FirstUse Is Null and MasterName=" & working.Master1.Value 'strSQL1 = DoCmd.RunSQL strSQL boxWeekBegins is the text box on the form, MasterName is a field...

Thanks for the suggestion, Remou. I'm using 'Field 1 is a date strSQL="Update tblTable Set Field1=#" & Format(Me.txtField1,"yyyy/mm/dd") & "# Where Field1 Is Null And ID= " & Me.txtIDNumber DoCmd.RunSQL strSQL and it keeps breaking at DoCmd, saying that the variable is not defined... I'm not...

Hi, I'm trying to write a code that: 1- Uses DLookup to find a value based on a criteria (which happens to be the primary key) 2- Check if this value is null, and 3- If it is, insert a value into a table from a textbox on a form. The thing is, the table is already created, so I'm not adding...

Hi Skip, Thanks for the input- I did want to represent the string, because it was the durations of two things that I wanted to put in the column. PHV solved the problem for me.

Yeah... I just redid the whole thing and it started working, I'm not sure why. Thank you!

Hi, I attached a report to a query that has selection criteria, so that when you open the report, it prompts you to enter in values (ex. a month). I followed the steps in Access Help ("Use a form to enter report criteria"). Everything works fine, but the system now pops up its own message box...

Hi, I'm trying to concatenate two Time fields in a query. Sometimes the second field will be null, so I wrote: (the lengths are associated with a MasterName) Duration: Format([tblMasterNames.Length],"Short Time") & ("/"+Format([tblMasterNames_1.Length],"Short Time")) and in SQL...

Thank you so much, that worked perfectly! I also have to concatenate lengths (in seconds), but I get #Error when I try this - [tblMasterNames.Length] & (" / "+[tblMasterNames_1.Length]) AS Duration Also, though in the table these lengths are in short time 0:30, 0:15, etc, they show up as...

Here's my SQL - Master1 and Master2 are the "Half Names" and ISCI is the Full Name. As I said before, sometimes Master2 in the ISCI table will be null, but Master1 won't. I need Master1 to show up regardless though, and right now, it only shows if Master2 is not null. SELECT tblISCI.Master1...

I've tried that, but it doesn't work because I'd be trying to join a Null in Half2 to nothing at all in tblHalf_1. I'm not even sure if what I want is possible..

Hi, I have three tables in a query - tblFullName, tblHalf, tblHalf_1 . tblHalf and tblHalf_1 are identical. In tblFullName, there are columns: FullName, HalfName1, HalfName2. I'm trying to link HalfName1 to its corresponding column in tblHalf, and HalfName2 to its corresponding column in...

Thanks a lot!

Hello, I made an option group ToggleFrame with 4 buttons, and wrote code so that when a button was pressed, it would change the row source of a combo box Combo1. The problem is, I think, that the combo box is on a subform (Sub_Form), while the option group is on the main form. I did it like...

Thanks MajP! It's still frustrating that I can't get the Format->Conditional Formatting option on Access to work. I'm choosing "Expression Is" and I need it to turn red if the Expiration date has passed. My list box is called Event_1, its control source is called Event1, the table from which...

That wouldn't really work for my list, because I need users to be able to see expired events, in case they want to renew them. But - do you think it's possible to include a button on the form (separate from the combo box) that you can click to change the row source for the combo box? For...