Search results

Thank you for the reply. Attached the image that I hope clarifies it. The bullet point isn't a necessary thing I just have it in there for now.

I have a report that groups by a project name and then a repeating field to list all associated detail having to do with the project. Then the projects loop to the next. (sorry for the periods in place of spaces - I couldn't see how to line up correctly otherwise.) This is what I'm shooting...

ok, this is about as far as I can go with this. See attached database example (it's zipped). Oh yeah - at this point, you have to enable macro's to let things work right. Table_1 - Vote overall Table_2 - Voting possibilities Table_3 - Ballots Cast Table_4 - Member Listing frmVoteEntry -...

i'll update the database sample, one min

Right, You could have a couple different scenarios. Overall you want a vote/ballot/voting set of tables where the vote table is the main one, ballots uses the vote id to store all possible voting choices and voting tables which uses the ballot id to store the record of what was cast along with...

without knowing what you've tried i'm sort of throwing darts. I'm assuming you have people vote - and the votes are into a table. You then want to see the results of the voting? Queries and Reports both have wizards that can pull that together for you. Here's an example of using Report...

what have you tried so far? seems like a query or maybe a sum query would suffice?

I think that part has to do with tab stop being set for the control. Nothing to load and nowhere to go. But like you found out - setting correct tab order solves your problem.

hmm I think I see what you're trying to do with that extra information. You want to be able to click a name from form1 - have form2 show any previous notes in datasheet view but additionally enter the customerID in the new record row of that datasheet view. You *may* be able to do it by vba...

Then additionally set Pop Up to Yes.

I take it the 2nd table has a column with the first tables customer number? That's what you'd need to link them. You can do an onclick event that opens the second form (which has the default view as Datasheet. Set "Allow Datasheet View" to Yes) with a Where condition set to have the ID field...

they probably mean not to seek help online too i imagine. What I'd suggest to do, is look at your control source of the fields meant to pull data based on another field. Essentially what you have now, examine it in depth and check your field names, table names etc. You're close you just...

isn't that fun. Sounds like you are referencing a different field. Any chance to upload the db?

For question 1 - do you mean set relations as in table level? For question 2: On the after update for Search Terms you could do something like this for VBA. (untested) Dim sSQL as String Dim db as DAO.Database Dim rs as DAO.Recordset set db = currentDb sSQL="Select * from <tablename> WHERE...

Hi ICTKirsten, I'm unsure what you are testing. Is the intended method -> Type Contact number, -> Dentist Forename, Surname and ID number fills or is it -> Dentist Forename, Surname entered -> User ID fills? Either way, what are you using as your control source for the data on which fields...

well I'll be damned. I should have thought it was Windows related. Thanks!

I have to agree with Gemma - it's not your database if you developed it on the company's dime. jdraw has put some fantastic information there. Design documentation (including release info), users guide, admins guide, quick guide. Comment the heck out of your code and only tested and approved...

I've searched around and tried various fixes such as setting auto resize and auto center to No without any change. For example if I open up the Access database on my left monitor, then move it to my right - whenever I switch from design to form mode the form disappears. Moving Access back over...

If anyone else needs this. First upon loading the main form page I checked for the users temp table, created it if it did not exist and set a tempvar for the Users username (after converting it to only alphanumeric. Then i have VBA pushing and shoving things through tables as normal. For the...

I should have mentioned split, dont know why I didn't think of that. It's reversed in this case. When the report gets generated the tables get stored in the front end. All the rest of the data is in the back end.