Search results

I’m creating a database for the first time and am new to VBA Access, please. When I click a button on my subform (which is in continuous view) it opens another form, Node Setting Form ("popfrmNEWNodeSetting2" in the code below). The pop up Node Setting Form will open blank with no fields for...

That is very good advice. I'm going to keep that in mind: 'Cut down on scrolling. Cut down on key presses and mouse clicks.' Thank you.

Thank you, Ranman256 and Minty. I just want to know that I'm going in the right direction and not making something that more experienced users will laugh at.

Thank you for replying. I am new to Access, setting up forms, tables, etc. from the ground up. That is clever the way you have your main form/subform set up! I never thought of that. I have a combo box on my main form that lists all of my customers, and a user can select a customer and it...

I have a main form and a subform with a one to many relationship, having many orders that appear in the subform under one customer in the main form. I have the subform in Single Form view b/c it looks nice, but I have to have the navigation buttons turned on the subform to be able to scroll...

Thank you, I didn't think about that re: the Design field. And, yes, I should have the nodes in a child table. I used to have it that way but thought that the nodes are always part of their own particular hub, so I put them in a table together. I appreciate your help.

The new, correct database has been added to post now. Thank you for any help; I would appreciate it.

I'm sorry, I attached the wrong database. I have read a lot and revised it many more times beyond what you saw. I will need to reload the correct db tomorrow. Thank you for your help and pardon the error.

**Poster's Edit 10/11/2016 8:45 a.m. - the new, correct database has been uploaded to the post. Pardon any inconvenience. I would appreciate any help.** **Poster's Edit: Pardon the error, but I have uploaded the wrong database. I have removed the attachment and will need to upload the correct...

Simon_MT, I tried looking at the function but I can't translate it into something familiar to me. Thank you, again, for posting. I would have to compare it to another code I found on a website. Thank you, again. I'm sure it would solve the problem.

Thank you, Simon_MT. I will try it out and see if I can use it and tailor it to what I am using it for. Yes, I wanted a formula, but I will try and see. Thank you for taking the time to answer. P.S. It might be the weekend before I can try it out, but I will get back to the forum with any...

Thank you for your reply, plog. I had problems with translating the theory from some other websites to my particular problem, so it's hard from me to follow without examples in this particular case. My work around is pretty long, but I learned something new about IIF(MOD, etc.): 1. I used a...

Hello, I’m using Access 2013 in Windows 7. I’m trying to use a formula that will tell me if a value from a field in the Design table exists in another field in the Schedule table. If so, then return an “A” in a new field I created in the Design table; if not, return a “B”. I know in Excel it...

Hello, I'm from the U.S. and I am new to this forum. I've used Access (as a user) for a long time, but not at an advanced level and my current job is requiring that I use it at almost an Administrator level, creating a database from scratch, creating relationships, etc. So, I believe I'm going...