Search results

Hi Gizmo, I would be very interested in your switchboard builder! It would answer quite a few questions I have about coding up my existing forms. :)

YES! It now works fine. :) I don't feel quite so stupid now. Any of these seem to work just fine. I thought I was way off. Just adding some brackets sorted the issue. BIG thanks to all (as usual) .

Oh, and I'm aware that there is a NEXT missing from the loop! :)

Hi, I've come across an odd issue that isn't clear so I'd like input from someone to point me in the right direction if possible please. It's probably easy and I've missed something fundamental! I want to design an unbound form that has around 60 rows of three fields. At this point I'm not...

It really wasn't a big deal. I don't expect to be "spoon fed" with this stuff. Sometimes you just have to get in there and sort it! It was the modules that got me. I didn't realise until I got into the code that they were required. Not to worry though. It's a good piece of code.

Hi guys, This has worked out much better than I thought. I was using some absolute paths for the Save buttons on my forms which have many unbound elements. This caused an issue when changing backends but I found that the relative path variable for the "changed" database is available public so...

Hi @MajP , Well.. over the weekend I installed the backend swap code. It was a bit of a learning curve to get it installed to my setup but it's now in there - and it works just fine. This is going to make my life a lot easier! Since it was a bit of a pain to install it, I'm going to write...

@MajP - Thank you! I really appreciate this! Everything is working nicely :)

I decided to just get on with it... Split and Linked the databases. Works fine. Much better! Now how can I provide a simple way to switch between backends for development purposes?

Ah.. just read up about splitting databases. Now things are clearer. The reasons all make sense too. I'm not going to get around to getting any of this sorted for a couple of days now but I have a great starting point! Many thanks to the contributors for your help! It's appreciated. :)

Ok. that seems to make a lot of sense. I'm very new to Access and I didn't know you could completely separate things like this. The terminology is a bit weird... Database... This is the whole thing including the tables - or can the tables be something completely separate? To me, the...

No, I just want to copy the accdb file containing all of it over. This contains all the tables and the forms. I just want to copy the accdb file and run it directly from the new location.

Or is there a way to read an .ini file to set this?

Hi, I'm confused about this... I have a fully running Access setup using several tables. Everything works just fine. However, I want to be able to have a folder containing a copy of the development system which is the same (including any changes I make of course) as the live system. My...

Ah... Reserved words... Didn't realise that "desc" and "description" were reserved. That makes a lot of sense. Will change them as I don't want issues in the future. The query also works too! Many thanks to contributors!

Thanks for your reply! However, I think I've located the main issue... I'll report back if it still plays up though... I performed an Office Update. I noticed that updates were turned off. I did an Update and now it's not doing it. Everything seems to be working fine again. Very odd. I...

Hi guys, An easy problem was solved yesterday using the forums but I now have another that is more serious... Everything within my database and forms has been working just fine but this morning I launched the application to do some more work and I find that pressing any of my search buttons on...

Perfect guys! Problem solved.

Hi Everyone. I'm very new to Access but am gradually getting to grips with it. I have a form that calls data from another table and places it in a field on my form using DLookUp. The data is being fetched correctly but when it arrives is gets squashed to the far left of the field window. I...