Search results

Wow! Way cool. Thanks for the post. I learned something useful today.

I'd do it the way you are. That's why I'd like to see the database. I don't understand why that's not working. I could (and have in the past) create a form, table and query based on the information in your post and do some testing but why should I do that when its so much easier for you to...

Then I suggest uploading a stripped down version. In your case I suggest just creating a new database and importing the applicable form, table and query, delete sensitive data from the table and upload that.

I can't see how. What's your end goal? Maybe there is some other way to do it.

On the other hand it should product a result if Date is not null no matter how you add to Week. Could you upload your database.

I suggest trying the DateAdd function rather than just adding 6 and see if that helps i.e., change ([Forms]![ShiftSearchForm]![Week]+6) to (DateAdd("d",6,[Forms]![ShiftSearchForm]![Week]))

In this web page Microsoft says if you can do that if No more than a few people are expected to use the database at the same time. No Memo fields are present in the database, or if they are, they will not be simultaneously updated by different users. Users do not need to customize the design...

Recently while I've been typing responses I find that the cursor disappears from the editor and I have to click on the editor to get my cursor back. This ad or ad space always seems to be present when it happens. If you close it the problem goes away. It would be nice if we didn't have to...

Here's a method that avoids the concatenation and the problems that it causes Const SQL = "Insert into tblAssignments ([Caller], [HowMany],[TimeStamp]) VALUES (p0,p1,p2);" With CurrentDb.CreateQueryDef("", SQL) .Parameters(0) = Me.CboCaller .Parameters(1) = Me.CboHowMany...

I'd check the form's record source for a form reference to the control.

I don't see the primary and foreign keys in these tables. If they are not added you definitely won't have a One:Many relationship or really any relationship at all. What are these keys? I don't know if it is relevant to your problem but I was reading this thread about retrieving the last...

I was initially getting a syntax error with the SQL as it is. When I change TimeStamp, which is a reserve word, to TimeStump it started working and inserts the full date/time. You can see this in the attached database. Edit: If I put the field in brackets like strSQL = "Insert into...

I don't know what you mean by "the "lesson Learned" is about/the form user selected". If you could elaborate a bit more on this it might help. No, the links I've posted do not say anything about getting rid of them. I believe in your case all you would need to do is change the Display Control...

You current structure does not allow a Lesson Learned to be related to multiple facilities. To do that you would need to add a junction table between the facilities table and the lessons learned table. This would create a many-to-many relationship between facilities and lessons learned. If...

Definitely not On Change. You want the form On Current event and I've confirmed that you do need it. Open the frmLessonLearned form in design view Right click in the form and select Form Properties In the Event tab at the very top click on the ellipses of the On Current event Choose code...

What info would be saved to all the facilties tables? And is there more than one facilities table?

I've attached the database in which I tested the code. The button (Add Payments) is on the frm_hire form. Maybe you can figure out what's different. If not then upload your database and I'll try to figure out what's wrong.

Explanation of Solution This explanation discusses the solution in the attached database which has change a bit since the last version. Please refer to it for the following discussion. If you add form references to the queries that are part of the crosstab query the references must be added...

There is code in the Maintenance Program module that helped make the frm_link_outs form. The New Controls subroutine is what I used to add the textboxes. So if you are going to redo the form try to figure this out as it will save you a lot of time. Bed time now for me. I'll get the...

I was just thinking that for the cboClientFacility combo to show the correct facility for existing records you will probably need to put Me.cboClientFacility.Requery in the form's On Current event too. A good start for VBA is this video series.