Search results

@Brianwarnock: That was it! Thanks. For anyone that wants a more detailed explanation of my problem and the solution, please feel free to read below. You da man! I have a field called EditFormDate that shows the date a schedule was created for. Schedules are created several days in advance...

The EditFormWeekday field is just a copy of a date field, formatted to show the weekday name instead of a numeric date. I have an EditFormDate field which contains the actual date (like 5/9/14) and the EditFormWeekday field fetches that and displays it formatted as "Friday" What I want the...

Brian, Well, I was trying to make it easier to understand. In actuality, there IS a wild card (there are TWO), because the employee's days off are written with two days, separated by a comma. The query is looking for the presence of the value in question contained somewhere within that field...

[SOLVED] An IIF statement with a Date-1 Hi everybody. I have a query that fetches the value of the EditFormWeekday field on the frmEditForm form (LOL... that sounds hilarious when I say it in my head... must be the drugs...) Anyway, this query is supposed to filter the list of names based...

Hi folks! I'm trying to create a report that's based on a query, and the query has three fields: [PersonName], [PersonDate], [PersonShift]. This table holds records for people that worked on certain days and certain shifts. What I want to do is create a report that gives a graphical calendar...

YOU DA MAN, BOB! OMG, that's great, sir, thanks so very much! What, exactly, did I do wrong in my block of code? They look exactly alike! Thanks and reps given! EDIT: Found my mistake. It was in this line: If Me.[sbfmAssignments subform].Form.RecordsetClone.RecordCount > 0 Then I forgot...

I just found this on another site, and tried it, but I get an error message: 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim strSql As String 'SQL statement. Dim lngID As Long 'Primary key value of the new...

Hi Bob. Thanks for the reply. I've attached the requested version of the file for you. The database is going to be used to keep track of employee assignments for a small work crew for an entire month. For each day, I'll create the date/shift they're to work, and then list each employee...

Hi folks! I've attached a sample database below, and I'm hoping one of you can teach me how to accomplish this task: On my main form (frmMain), I have a button that is supposed to duplicate the Main Form record, and also duplicate all associated records from the subform. I know how to...

I've added that code to a new command button on frmMain, and have updated it so the 'fieldX' designations match my actual field names, but clicking it does nothing. No new Models are added to tblModels, and none of the items in tblParts are duplicated and set to the new ModelID. Did I miss a...

TJPoorman, a couple of questions, if you please (because I'm really a horrible newb at SQL, so I like to learn how things work... please bare with me!). My questions are numbered, and in RED below: Let me ask a different question: Say I have frmMain that's attached to tblModels. And on...

Hi folks. I've built queries using the Access Query builder, and I'm hoping one of you can help me with this. I have two tables: tblModels and tblParts. tblModels has primary key ModelID; tblParts has primary key PartID, and also has a ModelID field that's hooked to tblModels's ModelID with...

No but you might get an error message that Access can't find the object. The 'window' in this case would be your form. If you have the form's Save property set to PROMPT, then the form won't close until you answer the prompt. But once you answer it, the form will close, whether you save or...

When your database is done, create a password entry form to gain access to the Administrator panel (upon which you'll put the functions that only the Administrators - not the regular users - can do). Create the summary report, give it a name. Create a control panel for your application, and...

I'd write a query to filter out any records in that table with non-numeric data in them, and modify those records to get them acceptable for the number data type. Then delete the relationship for that field in the relationships window, and reopen the table in design view. You should then be...

I don't know if anyone's told you this lately, JHB, but it's people like you that make this forum so worthwhile and valuable for us newbs. Thank you so very much! You, sir, are awesome. Take care!

Okay... I think I see what you did there... Can you explain this in a little more detail for me? I'm still a bit new at SQL... Private Sub Form_Current() Dim dbs As Database, rstClone As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT EmployeeName FROM...

Okay, JHB, I see how you accomplished that, and it works great, but not for the database I'm using. In your example, you have that ENo table, which I guess would represent my Employees table. In your example, the ENo table has a column called "IsClicked", and the value of that column changes...

Plog, you are the man, sir! Thanks so very much! I apologize for those that might read his reply and wonder what he meant by his reference to 'needing a hack.' I edited the reply he's referring to, and removed that bit where I explain why, and therein is where he found that I really did need...

Long-winded explanation as to why this trick is needed was removed UPDATE! I ALMOST got it to work using the following SQL statement: UPDATE tblEmployees SET tblEmployees.Count=tblEmployees.Count+1 Where tblEmployees.EmployeeName = sbfmScheduledAssignments.Name But I get a parameter value...