Search results

My answer to them will be, If you don't like Access, then program it in something else for me. :)

Thanks for the information. Sounds like I need to schedule a long meeting with my IT department.

Thanks for the follow up. I like the idea of using a .bat file. I will have to consult with my IT crowd about the rest. I actually am trying to use the Access vs wifi problem as justification to have hard wires installed. I think I am making some progress in that area. For the moment, I think...

If I knew what you were referring to I might be able to respond. I have no idea what a Jet/ACE BE is. I am a rookie user. I also have no choice but to run Access over wifi as there is no wired option at the work location. At this point I have not yet split the database into front and back...

I originally had it split across 4 tables. however due to being forced to connect to the server where the database is located using WiFi I kept losing sync between the tables. I had to solve this by putting the maintenance records in one table. The subform is using datasheet view and is read...

Welcome As a person new to Access, this group has helped me a LOT. One note, when you post a question, put in the beginning that you a new to this and most members will keep their answers more basic. I asked a couple questions early on and got answers consisting of a wall of VBA code that made...

Thank you. I may be able to use this information to push for a wired connection to be added to my work area.

My database is on a server and I have no option other than connecting through wifi. It sounds like this is a bad thing. What do I need to watch for and what protective measures can I take?

Thanks For responding. It looks like a subform is the way to go. It is working on my sample database. I am transitioning it my actual db now. I need to do more testing, but early indications are positive.

That is EXACTLY what I am looking for. Now to go look at what you did so I can do it my actual database. Thank You

Sorry for a bit of a rambling response. Kind of thinking as I type. I maintain Test and Repair records on a variety of electronic equipment. We currently have over 6,000 entries going back to June of 2018. Originally we used an Excel spreadsheet for recording the data. I transitioned it to a...

Dogs will avoid messing their "home" (Crate) if at all possible. Of course a puppy does not have the control of an older dog. "Messing" his crate should be the least of your worries. Just put something under the crate that can be cleaned if needed, Think old blanket etc. Also it may help to...

Thank you for the response. Your comment about spaces in names is duly noted. It does look like a subform is the correct choice (Time to learn something new) My concern is that in looking at the help files, the data in the main form and the sub need to be in 2 seperate tables. That is not the...

I have extremely limited experience so please be gentle. I have a maintenance database with over 6k records. I have a form for entering the individual tests. I have made this form a split form. When I enter the Serial Number in the Main Form (left side) I want the Split Form(Right side) to...

THANK-YOU! As a person that is an Electronics tech by training and now being pressed into service to write and maintain a database, this is a problem I run into a lot, when using this site. People assume a level of knowledge about writing code in general and VBA in particular that not everyone...

Must have been something like that. Thanks. Sometime having the obvious pointed out helps.

OK, Now I feel stupid. I tried that before and It would not work. Now it does. It kept saying it could not find the name "Go Knights Go!" Now it works fine. Thanks for helping

I have a macro to check for a password before opening a form. (I know not the most secure but secure enough for my need) I have it working with a number password, but I would like to use a text password. Right now it is "5234" and i want it to be, for example "Go Knights Go!" What do I need to...

Although a valid point, I highly doubt we will ever have 99 employees doing this job at this location. in 10 years the most we ever had was 7 in the section and only 3 actually did work that the would have used the database had it existed then. I thought I was using just 9 or just 99 instead...

Thank you. That worked. I did find an additional problem however. I have an employee using number 9 and I had 99 for tests by those without their own number. My query was lumping test by 9 and 99 together. I solved it by changing my not assigned number from 99 to 0. Might ot be hte best way but...