Shawn29316
Last Activity: Jul 26 '18, 07:01 PM
Joined: Feb 28 '07
Location:
-
Shawn29316 replied to Need query to show status on first day of month but data has dates throughout month.in AccessJust what the doctor ordered! Thanks! -
Shawn29316 replied to Need query to show status on first day of month but data has dates throughout month.in AccessNarender,
Thanks for your quick help with this. Your solution got me a lot further than I could have gotten on my own but it's not quite what I need. I need to know how many employees were status 3 on the last recorded date every month....and that date could vary by employee.Leave a comment:
-
Shawn29316 started a topic Need query to show status on first day of month but data has dates throughout month.in AccessNeed query to show status on first day of month but data has dates throughout month.
Hi,
I have data similar to this:
...Code:RecordNum Date EmployeeNum Status 126 9/18/2017 10211 3 127 9/20/2017 10212 2 128 9/20/2017 10213 2 129 9/21/2017 10214 3 130 9/21/2017 10215 2 131 9/26/2017 10211 2 132 9/26/2017 10212 3 133 9/28/2017
-
Moving TempVar value into a table using a query.
Hi,
I have a query that says:
The query works fine until I try to use it to populate a table, then the ReqNum field is always blank. The only thing I did different in the query was to place "INTO EmpBIDs" before the "From Bids" in the original query.Code:Select Distinct Bids.EmpID, Bids.PosID, [tempvars]![reqnum] AS ReqNum From Bids;
Is placing a tempvar value into a table using... -
Oralloy,
I noticed by your name there's an "expert" tag. That obviously doesn't describe me so there may be a simple way to do this which I just don't know.
My logic for the queries was to use one to create a table containing the question number and a blank field for each race/gender combination. Then there would be an update query for each column to add the data for each race/gender combination.
...Leave a comment:
-
Looking for an efficient way to build a report
Hi,
Please see the attached file, which tells a big part of my story. The numbers represent the number of folks who answered "Y" to each question, based on race and gender. There could be thousands of lines of data as well as a few more race/gender combinations.
I'm looking for an efficient way to get from the data example to the report. I know I can create a table that looks like the report example the... -
Thanks Nico!
I'm not a great programmer and I thought flexing the size of the group would be over my head.....and it seems I was right.
I appreciate the help!Leave a comment:
-
Easy Update Option Group
Hi,
I have a split database which contains a couple of forms with option groups. These represent people in roles like industrial engineers. Since people change jobs from time to time, I'm looking for a simple way that I can manage the entries (options) in the option group, without having to redistribute the front-end of the database every time someone changes jobs.
For example, today's list should include Sally's name but tomorrow,... -
Near Surrender! Can't "lock down" database.
I've written a database which captures information about the user and grants access to 1 form, based on the user swiping their ID badge. It works great!
Now to my problem. I have to manage what general users can and cannot do but I can't figure out how to do that for every area.
I figured out how to hide the ribbon and menu bar, except for the "File" menu and the little drop down that says "Customize... -
I really don't know how to explain the recordset. The main form's Record Source is "SELECT T_JB_JobDetail. * FROM T_JB_JobDetail; " and the source for the subform is a query whose SQL I'm pasting here....Code:SELECT DISTINCT TOP 1 T_JB_Bid_Winners.EmplID, T_JB_Bid_Winners.BidFromJobID, T_JB_Bid_Winners.BidToJobID, T_JB_Bid_Winners.Name, T_JB_Bid_Winners.[Total Points], T_JB_Bid_Winners.Title, T_JB_Bid_Winners.RecID, T_Wage_Report.FirstOfGRADE555
Leave a comment:
-
SetFocus gives "can't go to specified record" error
I am trying to do such a simple (and devilishly frustrating) task.
I want to hide fields on a subform when the main form opens. Once a value is chosen from a combo box in the main form, the corresponding subform values will become visible.
I've read a lot on the subject and most folks say to create a "dummy" field or button on the form and set the focus on that object. I've tried that with a button named Command58 but I... -
I still didn't get the global variable to work. I assume it's just a syntax problem but.....
However, I tried the TempVars option (first time I ever heard of it) and was able to make that work. I'm thrilled to get over the first of what I'm sure will be many hurdles!
Thanks mbizup!Leave a comment:
-
Can't pass global variable value to Access query
I've read a hodgepodge of suggestions all over the internet for passing global variable info to Access queries but can't make it work for me.
I'm using ACCESS 2010. I have a form with 3 subforms. The subforms are almost identical and each has a button which should open a report. I want to have one report based on one query which receives its criteria based on which of the 3 buttons is pressed.
Here is what I've cobbled... -
I've made a change since the first posting once I realized EmplID is a text field. Now it says:
As I step through the code, everything is fine if EmplID isn't blank but if...Code:If (rstPostings("EmplID")) = "" Then MsgBox "There are no bids for this position" Else ... Err_btnCommand18_Click: MsgBox "You Must Select the Job to be Filled"Leave a comment:
-
error handling overriding normal situation
I have a button in my database with common error handling code. My problem is, there's a normal situation (no bids for a job) that I want to use a message box to explain to the user but the error handling takes over.
...Code:Private Sub btnSubmit_Click() On Error GoTo Err_btnSubmit_Click ... 'below is what I want to happen if emplid is 0 If (rstPostings("EmplID")) = 0 Then MsgBox "There -
NeoPa,
Thanks for your help. I thought the issue had to do with quotes and I'd be ashamed to tell you how many places I had tried to put them.....just not the right place.Leave a comment:
-
My code keeps dropping the leading zeroes from a text string
I stripped out some stuff but the code that matters is:
I put a message box in to display the value and it showed the leading zeroes but when I look at the text field I'm trying to update, the zeroes are missing.Code:Private Sub Command18_Click() DoCmd.RunSQL "Update T_JB_InputData Set Position = " & Me.BidJobCode.Value End Sub
I'd appreciate any help you can give me!
Shawn -
zmbd,
Reading back through my post, it's probably only clear to me what I "MEANT" to say. - Sorry!
What I'm trying to figure out is how to create the table to hold the relationship between the data elements. I used the multiplication table as a visual but I'm really trying to figure out how to best design the table. Should the table look like the output from the query you wrote above or should it be 3 columns (element1,...Leave a comment:
-
"Multiplication Table" type issue in ACCESS
Hi,
I have an issue very similar to the chart we used back in the stone ages to learn our multiplication facts. You remember, 1 - 10 as row headers, 1 - 10 as column headers and where the row and column intersect, the result of multiplying the column header by the row header.
For my data, if I did this in Excel, I'd have 170 columns and 170 rows but I'm not sure that's the best way. I'm assuming that I need 3 columns (column,... -
Mr Forbes,
I appreciate your interest in helping me! I decided to go a different direction that I could make work so I'm okay for now.
I've been given an assignment that's over my head so please don't be surprised if you see more questions in the next few weeks.
Thanks,
ShawnLeave a comment:
No activity results to display
Leave a comment: