Search results

Thanks, JLeach. I'm thinking I will need to make the nav bar a subform, and put it on the other forms, for 1 reason. Some of my edit forms, like for project plans, have subforms and sub/sub forms. I don't think I can go that many deep. It does mean I don't get the advantage you have, where...

Thanks for your reply. The add projects has a text box and 2 list boxes. The left listbox has every project that is NOT in the system yet. You can use the textbox to type a filter, as there are over 80,000 not in the system. Double-click one, to move that to the listbox on the right, for...

Pat, That's a pretty good summary of my issue. Users will generally go in one direction, but they can bounce around a bit, and that makes this complicated. I'm still pondering this and will be thinking on it over the weekend. My head hurts lol.

Yeah, I was thinking of something like that, but I wasn't sure if I could handle it in public functions, so I'm not having to explicitly keep track of the form's names in the code, with passing arguments and such. I'll have to do some searching on Access forms and bread crumbs.

Forewarning. This is a very general question, though I will explain what I'm working on, to give as much context as possible. I'm looking for different ways people are handling the need to have the ability to jump back and forth and all over to different forms in an application - basically the...

OMG you are a darn genius. I have always struggled with this, and there was never a clear solution. This solution gets to the heart of an issue. They didn't account for the direct changing of column width in data sheet view, but account for it, when saving other formatting changes. So...

This was exactly what fixed my issue, and I can't thank you enough!!! :D

Just found this post, looking for a similar solution and this post has everything I needed to do exactly what I want to do. Thank you for post and answers!!!:D:D:D:D:D:D

That's interesting. Do you know why that is? Why, if I clean up the whole statement, can I run it in SQL management studio, but not in the QBE? Why is access unable to read a perfectly good SQL statement?

for the ones that weren't working, I followed your advice and let the QBE dictate the syntax. It's annoying, because it's way more text than should be necessary, but it works. My OCD nature likes it cleaner is all. Thanks for your help.

I hear you on the brackets. But I did have to convert it. I had to take SELECT s.ID, s.txtStaffName FROM tblProjBuildStaff pbs LEFT JOIN tblProjAssignBuilding pb ON pbs.FKProjAssignBuilding = pb.ID LEFT JOIN tblStaff s ON pbs.FKStaff = s.ID WHERE pb.FKProject = 99 ORDER BY s.txtStaffName...

it worked in the QBE. I had to clean it up to convert it to VBA for the sql rowsource. I always clean up queries to put in aliases and take out un-needed brackets. If I run that query in sql management studio, it runs. The query is a working query. The issue is Access is choking on it. I...

That's the thing. I did build it in the qbe. Then I cleaned it up in a text editor to remove all that bracket junk on purpose lol. It's so unnecessary! Isn't it??? What is wrong with the aliases? I noticed one typo, but that is because I had to alter the statement that I would post on here...

I have a combo box, that has the row source set by vba with a case statement on change of a different combo. Based on the selection of the first combo, the entire row source is set to a sql statement. For 4 of the 7 options, I have the row source working and populating the 2nd combo...

It won't be the easiest to clean up, but it can be done. In the table where you have the text key, is the field linked through the table design to that text value in the other table? If so, that field should have a row source. If so, you can adjust the row source to the id column. Then you...

I have a fill-in pdf form, with fields that match database table fields. My database is in SQL, but I use Access for the forms and reports. The users will go on-site (and be offline), fill out the pdf forms a bunch of times and come back with a folder of them. I am looking for a way to...

Ok, I got a little confused with your table descriptions. Let me give you an example how that benefit of Access works, and then you can see if your tables are set up in a desirable way, or if you might want to reorganize them a bit. Each table should have an ID set as the primary key, and...

If it is really that simple, you can just open the table and do a find and replace for any part of the field. Always back the table up before doing that kind of action, just in case you find there is a sub-string in the path that also has what you are trying to find and replace. Sometimes we...

I have a formula, but it is not calculating correctly. AvgCostPerGal: IIf([txtCarCostType]="Gas",IIf(Sum(Abs([tblCarCost]![FKCostType]<>6)*[tblCarCost]![CurCostAmount])=0,0,IIf(Sum([intGallons])=0,0,Sum(Abs([tblCarCost]![FKCostType]<>6)*[tblCarCost]![CurCostAmount])/Sum([intGallons]))),Null)...

I have a main form for entering new projects (cases). There is a subform that has a key table as it's control source. The key subform is for linking a case to Assets (or media received for that project). There could be a CD, DVD, etc. Each of these assets can belong to multiple cases, which...