Search results

What they want to see is how many times each combo of selections were used per user. So the report would look something like user 1 combo 1 'option 2'.....combo 2 option 1....combo 3 option 5 Total 2 combo 1 'option 1'.....combo 2 option 3....combo 3 option 1 Total 1 next combo next...

Hi, In my db, when the user is entering data they have 3 combo boxes that they make selections from. So I've been asked to make a report that shows the total per user for each combinations of seletions from the combos. For example: a user can select from combo 1 option 2 combo 2 option 1...

I'm having the same type of problem with a db right now, only my backend is locked. There is no .ldb file, but if I try and rename the backend or open it. I get a warning about the file being in use. I'm going to see if IT can reboot and hopefully that fixes the problem.

Thanks! This looks pretty good, but how does it work? I've tried copying the code over to my form, and adding the checkboxes to my form. But when I press the command button it doesn't do anything. So I must be missing something, or not seeing something.

Hi, I was asked today if this is possible, when the users are making entries in the form. One of the combo boxes they select is normally the same option for many records throughout the day. What they asked if it would be possible, once they make a selection in the combo on their first...

Does anyone have any ideas to why it's doing this? It just did it to me again, I've had it open in the background for about 30 minutes, just went back to it, and the subform is showing older entries again. I have my subform setup like this allow filters: no allow deletions: no data entry: no...

OK, it just happened to me now. I had the db open in the background and have been working on something else. I just went back to the db, and the record navigator was showing 1 of 24 records, which is all the records under my id. I shouldn't be showing any, since I haven't entered anything...

Hi, I have a main form, with a sub form. The sub form is where the users enter their data. I have it set so it opens with a blank form, and doesn't show any past data. It will only show records based on the current session. I also have the filter properties set to no. I have one user...

Yep that was it, I should have known that. Thanks for your help.

I just tried this, and when I try and make a selection I get an error can't find the macro 'If isNull(Me.'

Hi, I have a form, with some dropdowns that are bound to some table fields. In the table I have the fields defaulted to 0, and on the form I have the dropdowns defaulted to 0 too. But here is the problem I'm facing, if a user is making an entry and accidently enters something into a...

Thank You, I'm going to play around with this and see if I can make this work. I'm affraid tho, like neileg said that there might be just too many combinations of codes to make this work, and still be able to maintain. I looked and there are currently 25 codes they can select for each of those...

This is exactly how I'm feeling, that it's just going to be too complex to actually implement, and then try to maintain. There could be so many different combinations of codes/comments, that's when I came up with just allowing the user select the appropriate comments, since they know what...

I'm not visulazing how that would work. Right now, each code type field has maybe 20 or so codes that could be selected from dropdown So on the form, field A they make a selection. Then do the same for the Field B and C. Example 1. If Field A has code 2F. It would normally say comment...

That's what I have now, I have a comments table. Where they can select the comments they want to use. It's the automation I don't know how to do. I don't know how to make it so it pulls the appropriate comments, depending on the combination of codes selected. They even need a special comment...

I'm not sure where to ask this question, it's a complicated one. Not sure if this can be done with a query, or in a report, or if it's even possible. In our database we have 3 fields. We'll name them FieldA, FieldB, FieldC to keep it simple Each field represents a different code type. We...

Hi! Thanks for your help, this works pretty good. They have another request now, and puts another kink in the query. in our data table, we have a start date/end date fields. they only want to see codes with 2 or 3 records that don't have the same start date. Is there a way to filter out...

Hi, I've been asked to create a couple queries for my db. I have a code table, and then a data table with a code_ID (FK) to the code table. The first query would to see how many codes have only been used once. Then another query that pulls codes that have been used twice. Then another query...

It turns out she didn't have write permission to the network folder. So I just requested access, so once that's set hopefully this fixes it. Thanks everyone for your help.

Ya, that was the first thing I did. But she is still having the problem. Could it be a security thing? Maybe she doesn't have write access to the folder the backend is in?