Search results

Hello, I'm using docmd.browseto to populate a subform that is filtered to a date range and combo box selection. DoCmd.BrowseTo acReport, "Master_Report", "Main.NavigationSubform>ReportCenter.sfrReportPage", "[Activity_Date]>[TempVars]![tmpStartDate]-1 And...

That does it perfectly! Thanks

Hi, I would like to have a text box display the number of records for a selected title that fall within a selected date range. Been looking around for a while and have this so far; =DCount("Discussion_Title","Discussions","[Discussion_Title]='" & [cboType] & "' And [Discussion_Date] =...

That does it. As I was reading the SQL I thought of that but figured I'd wait for to see what someone else had to say. Thanks

Hello, I have a combo box that I want to display titles of discussion that fall within a date range. I set up the query as such; SELECT DISTINCT Discussions.Discussion_Title, Discussions.Discussion_Date FROM Discussions WHERE (((Discussions.Discussion_Date) Between...

Got it working the way I want with a combination of your two answers =[Form].[CurrentRecord] & " of " & Count([TrainingUser]) This gives me what I wanted "1 of 10" Thanks!

Yeah, that's all I'm trying to do. The code for the current record number works but the code for the number of records keeps returning Name? errors. Might be because RecordsetClone and record count are not in the list of Expression Values. Any ideas? It'd be nice to put "1 of X" on the form...

Hi, Wondering how to make a text box on a form display the record number so it can be seen along side record selector buttons. I'd rather have my own then use the record selector option that displays at the bottom of the form when enabled. Thanks, Ryan

Hi Bob, I was just doing the same thing myself, but you're right I am using the Option group with two radio buttons. So I have UPDATE UpdatedActivity SET [Action] = IIF (Activity = 1,"Login", "Logout"); Works perfect. Thanks for the input about the IIF statement

Hi Bob, I tried to do that with no luck. I have found some succes thought with the following SQL statement UPDATE UpdatedActivity SET [Action] = "Logon" WHERE [Activity] Like "*[1]*"; Here I've made another field called Action and am setting its value based on the Activity field number. I...

Hi, I've made a simple form to Login/Logout with radio buttons but the buttons only allow me to push a number as a value, in my case 1 or 2 for Login or Logout. How would I make an update query to change those numbers to the equivalent text? Or is that not possible in the same field...

Found a solution in another thread and it works for me http://www.access-programmers.co.uk/forums/showthread.php?t=193282 But is there a way to do this in the query with a separate field?

Hi, I have a form generated from infopath where users enter the amount of time it took them to complete a task. It is set up right now in time format, so a user would enter Task A-0:15 (to show 15 minutes). Users have multiple tasks with different times and I would like to be able to show a...

Amazing, spent the last couple hours tyring to figure that out and was ready to go home for the night! Works perfectly. Thanks a million!

Hello, A quick summary would be that I'm trying to change a 1,2,3 in a table to display NA, Yes, No on a form. I have an Infopath form with a n/a,yes,no drop down that is dumped into Access. Infopath requires a value be tied to them so it is 1,2,3. So in Access, my table shows the numbers...

That is correct. Update the second box to null/blank everytime a selection is made in the first box.

I copied that code from somewhere else, all I know is that when when I go to select another agent from the first combo box, the second one will get updated once that selection is made. Without the code, the second combo box stays on whatever was my first selection and will not update when I...

Didn't change anything by adding .Value

Hi, I have a combo box (cbodate) and it's based on another combo box (cboagent). Right now when I select and agent, the date box shows the dates specific to that person and when I select one, I open a form with the info. The issue is when I want to select a new agent, the date box shows the...

Thats what I don't undertand right now. How do I make all these text boxes unbound if they are bound right now? Is that something that I can do? I know I can set the row source for a subform to something but how is this going to be linked to my combo box selection on the main form?