Recent content by Gaztech

Now... That is a question I can't answer! It's an obvious thing to assume. I have no idea at all. I copied the form, renamed it and then edited it. I'm sure it's something I did but I can't recall as I did the process a few times as I couldn't understand what had happened. Maybe each time, for...

Ahhh!!! I found it. It was a textbox that was hiding under the footer line at the bottom. It simply wasn't showing when I viewed it in design view. It's no wonder I couldn't see it or find it! Sorry guys. Me being a dumbass! I feel really stupid now...

This is the problem... I can't actually find DBinUse anywhere! Yet it works on the other forms. If I could find it, I'd know what is going on. That's why I think it might be part of the "Change Backend Database" routine. I'm going to chase it down through there first. And no, I'm not using the...

Hi guys, I have a split database with 7 tables. It's currently working just fine with an Access stock system that I wrote a few months ago. I just added two more tables to the backend database to add a record of repairs to stock. I then removed all of the tables from the application and...

Wow! That was easy! I didn't realise you could do that. That's a neat trick. Many thanks guys as always. :)

Hi, I have a small conundrum relating to the visible display of a field on one of my forms. This form is used for editing previously saved records. I have a check box, which when checked I want a field to then become visible so that I can enter data into it. My two fields are called: SUB_ASSY...

Hi, I'm not sure what the admins think of this diversion from the subject thread - should be bumped to another post really - but I'll continue just to answer your query... First of all, whilst psexec is a very powerful little program, there are many other ways to start programs. Using psexec...

Wow! That appears to work... Huh? The structure of these commands don't look that different to what I had so how come this works? That's weird. Even the Prev / Next buttons work correctly! I'm really pleased it was something simple after all. One thing though.... how come the last...

Hi guys, I have an annoying issue with the Me.Filter command and NEXT. I don't know if there is a quick fix or whether I need to code something up explicitly to solve the problem. Consider this: It's a button which when pressed, you enter a search clue to an input box and relevant results of...

All understood. However, the client in question here can't afford a server or all the software required to support the scenarios mentioned here. There are only 5 users on the whole network so the client can't see the point of the extra expense. I'd love to port it to a server and SQL but I'm...

Actually, no. I haven't. I always connect my development laptop on WiFi (despite telling others not to!). I don't really expect any issues either. Going forward, I don't want to have to recover things that could have been avoided. This was more of a "belt and braces" approach as we have the...

Yes Doc_Man - you are correct of course. However, in my situation the users will never need to access this remotely. They only need it when they come back in to the office as it's a warehousing program. As I said previously, I did have to change the name in the batch on one of the machines...

Yeah sure - they could open it directly but if they won't turn off the WiFi as they are lazy they certainly won't be bothered to look for the file and run it not using the shortcut! However, that remains to be seen :) I appreciate the input. We'll see how it goes.

Ok, So.... I have a simple but dirty way to solve the problem. It's a bit like a hammer to crack a nut but it works fine and doesn't involve coding up loads of stuff. IF you have several Access routines on the machine you can use this for all of them with no extra coding. I needed to find a...

I do the same thing! I have two button shortcuts on my Taskbar - one for Enable and one for Disable. These use netsh and the adapter name to perform the relevant functions. I'm sure we can go down this route somehow...