Search results

Thankyou very much for your reply, but I have managed to solve this a slightly different way. Solution: When opening a form in Add mode, only one record exists in it, so you can't use goto record next/previous. Instead in the Macro use goto record new, gotorecord previous. That saves it and...

I need to perform queries on data inside a form against the table the form enters data into. So, I need the data in the Stock table that the form is a data entry form in, without closing the form. Is there any way to save a record through a Macro without closing the Form? I need to use a Macro...

Only thing I can think of is that you need to check that both church service date fields are identical and both contact names are. Some generic advice too - avoid using these fields as primary keys. It would be much safer to have ID fields with autonumbers, and when you join on them the foreign...

I'm glad you got it to work, but as for the musicians side I'm not too sure. Can you send me a screenshot of the relevant relationships?

I have a report which displays details about stock items that are below their re-order level, and a sub-report which displays the same information for items which have been manually ordered. I'm making these as seamless as possible, which is so far working out fine. However, if the main report...

Okay that's not a problem. I'll leave it out - I just thought it would be a simple thing I was missing but it's not essential by any means. Thankyou very much.

I have a form that allows users to order Stock items using a sub-form. I have a quantity field in this also. I'm trying to control the quantity using spin buttons but unfortunately I cannot make these work. I have tried placing them in the sub-form but they are never visible. Is there any way to...

Not really. You just need to have a Date column you can query. I imagine it'd be more versatile without the calendar, so you can just put any date into the table. A calendar input could be useful for a data entry form for the table though, although I wouldn't know a lot about that idea.

The attached image should help you get started with how to get the new column. It literally just acts like a new column in the query and can have criteria applied to it (this will let you limit your combo box to saturdays and sundays only).

If you add a column to a query based on an expression, that will be added to each record. Don't refer to set dates, just the [date] value in the query. Have you ever built calculations or expressions in a query using the expression builder?

[CODE]Case 1, 2 If Me.txtDateOfReport = "" Or IsNull(Me.txtDateOfReport) Then Me.cboEmployeeName.SetFocus End Function End If If Me.txtLocationOfAccident = "" Or...

Okay, you need to build a form with a sub-form. The form will contain information on each assembly, and the sub-form will contain information on each part. I'm sure this project is meant to be a learning experience, and I'd hate to appear patronising given my fairly low level of personal...

When you say you're new to access, what experience do you have? Can you build a query using the wizard, and then add expression criteria using build? Can you use a sub-form? Can you build a macro using the Macro builder?

If you bind the textboxes into the fields you want to enter data into, and open the form in add view using a Macro, I think you should be able to use that part of the form as a standard data entry form.

Would it not be easier to build a Query on the dates, and add an expression to get the day of the week, and then base the Combo box on that query? You could then use the weekdays to accept as criteria. For example: -Query contains the dates to check in field "date" -Add a new field to the end...

No problems, best of luck with it. I hope it works out well, but I don't know anything about access 2007. If Access 2007 has Combo boxes in Forms, I'd consider one of them too for the song selection. And if there are any fields in your current system you'd like help with where to put them...

He mentions the ".form part" in the line below it, so I imagine it's meant to be a full stop. The actual code I used is an Access Macro with a requery, called in OnCurrent though, so I'm not entirely sure.

So, you have a song table that has Song Title, and you need to allow multiple Song Titles in the Church Service Set List form? First of all, a very important thing to consider is an ID field as a primary key for the song. Songs can very easily have the same names - and whether that's relevant...

Ah I see, thankyou very much - that'd explain why that code was producing an error before then.

I may be wrong, because I don't use the same version of Access as you, but I think your relationships may be broken. You have Church Service Date, and Service Date related - they should be the same name and identical fields. I think that explains the problem you're getting. You must use...