I have asked a question on the forum for what I was trying to do a certain way.
Maybe I should just ask for what I want to do.
I am trying to pick certain records from one table based on data from another record.
Table1 has a column of used idNumbers.
Table2 has a column of ALL idNumbers.
I...
Why would I get a statement for the sql criteria in a query that reads "At most one record can be returner from this subquery"
((select[tblPlatformCategories].[platformid] from [tblPlatformCategories] where
[tblPlatformCategories].[platformid] <>...
I have a query that one of the fields can have repeated values because it is repeated in the table it comes from. I would like to only have one of the repeated fields.
For example:
1000 1330 Bob Lowman 1330
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000...
I have inherited a database and ran across something I have not seen. I am sure it is a relationship with another table or query. Next to the left most column is the '+' sign that expand to records. Can someone give me brief explanation of these and how they are implemented and can they be...
I have a report that looks like the following:
Market
Project#
Note
Project#
Note
Project#
Note
Market2
Project#
Note
Project#
Note
Project#
Note
Sometimes a given Project# has multiple notes entered. Right now my report will handle the multiple notes...
Thanks for the response. I have a couple questions:
1. In the Join, choose ALL projects and notes that match?
2. This expression should be in the Field: section?
3. I know you don't know all my data but I am trying to match up you code with my data.
NotesEngineerField is the...
I am trying to do an complicated report and am looking for some ideas on how to do it. This hard to explain ( I think), but what I want to do is run a report based on
project category
project number
and all notes that where entered for those projects
The tricky part is if there is a project...
I have a front-end database that is linked to a back-end. The back-end is a replica. I recently re-did the back-end, added some tables. I have never had this problem before when I have had modifications but the following happens now:
I can refreash the link between the front-end and back-end...
I am trying to synch 2 databases, a master and a replica, but I get the error message:
The Microsoft Jet database engine could not find the object 'MSysCompactError'. Make sure the object exists and that you spell its name and path correctly.
I see some of my other databases have this table, it...
Also, the Allow No New Record property doesn't help me. I would like to allow a new record under certain conditions. I could do it in VBA if there is a way. Thanks
I have a form that is populated witha query. I would like to not allow the form to keep forwarding to new blank records. For example there are 12 records, when you use the record controls and get to record 12, you are not allowed to go to 13, or at least not 14.
Thanks for the help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.