Search results

Perhaps I should write to a temporary table and use it for a data source?

Ok... moving on. I have a new continuous form that I push a button and it fills with the filtered records from the original list. It only fills a couple fields as it is only a working list that on click pulls up the detail form for working. Now I'd like for the form to maintain the data even if...

It doesn't requery but it does seem to refresh according to the filter. Stupid idea. I'm thinking now about adding the filtered list to a listbox that doesn't change unless a new filtered list is added. He could work from that list and still jump around on the continuous form and it would always...

I have continuous form that I filter by followup date. When I click on the first followup date a detail form opens and I call the client and update various things and change the followup date. Then I'd like to return to the list and go to the next client. I have a close button that returns me to...

You guys are good! Thank you so much.

Ok, Plog. I admit I lost my mind there. Fixed, thankyou very much. So here's my problem: That red stuff... These queries all work but I wanted to put them in vba so I could use variables for the dates. I have to make a temp table because it's the easiest way I know to get sequential numbers on...

by don't work I mean I can't get it accepted in the vba window. Which I assume means it isn't a true string. It stays red so I can't even debug it. Where would I put an equal sign?

I cannot get these two formulae strings to compile Dim moName As String moName = "Choose(Month([WhatDate]),'January','February','March','April', " & _ 'May','June','July','August','September','October','November','December')" Dim daName As String daNsme =...

Well! I missed that too. I'm using your query arnelgp! Exactly what I need. Thank you very much.

I need 728 successive weekdays starting with a date. Between #5/1/2024# And DateAdd("w",727,#5/1/2024#) This makes the correct number of days but it includes weekends. Doesn't the "w" limit it? So I limit the days to <>7 and <>1 This limits the dates to weekdays but brings the total to 520. What...

This works because the main form is only a treeview for selecting records. The only change is changing the focus.

AARRGH!!! Do you know how long I've been staring and messing with this? Thank you so much!!!

I have a main form with a subform. Private WithEvents subFrm As Access.Form Private Sub Form_Open(Cancel As Integer) ' set withevents variable to the subform object Set subFrm = Me.fsubDetail.Form ' ensure subform object raises Current event subFrm.OnCurrent = "[Event Procedure]"...

Aargh! They're numbers but the sql didn't error! I've fixed it.

Really? Who knew! Thank you

ahh... if anyone cares, here's what works: Public Sub AddJunctionRecord(LocID As Long, ItemID As Long) Dim strSQl As String 10 strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _ "VALUES(" & LocID & ", " & ItemID & ");" 20 CurrentDb.Execute strSQl...

Wait... Now it says too few parameters; expected 4. Is it playing with me? Public Sub AddJunctionRecord(LocID As Long, ItemID As Long) Dim strSQl As String 10 strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _ "VALUES (“ & LocID & “,” & ItemID & “);" 20...

WELL! You are so right! Thank you so much!

Even if they're actual field names and not variables? The Insert statement isn't that way. Is it right?

I've been over and over this: Public Sub AddJunctionRecord(LocID As Long, ItemID As Long) Dim strSQl As String 10 strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _ "VALUES (LocID, ItemID);" 20 CurrentDb.Execute strSQl, dbFailOnError End Sub Returns the...