Search results

(Rookie Access user) When I try to create a ACCDE from my database, I get an error that says Microsoft Access cannot create the file. Reading through the forums, it appears that the most common problem is with bad VBA code. I have no self written VBA code. Everything I have is done by the built...

OK I guess this was the key point I was missing. Time to research ACCDB vs ACCDE. I think I know the difference. which usually means I just think I do and really don't. And your point about "overwriting" vs changing the BE directly is noted. I work in a very small office where max users are 5...

Jumping in here with some questions/ need for clarification of my own. (Noob user. please be gentle.) The back end is ONLY tables? And the front end is everything else? And if I want to make a change, I copy the BE file to my PC, make the change, then copy back to the server, overwriting the...

I went to open the files and Google says they do not exist. Are they available from a different source?

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.