Search results

I'm sure the answer to this is straightforward, but I've been hunting around on Access' help, these forums and elsewhere, and can't find any examples or solutions that fit with what I need. Basically, my user is sitting on a form, frmSearchOnline. On this form are unbound text fields for...

Ah, just spotted the flaw in my code. It now works, but thought I'd post here just in case anyone else was having the same issue. I've simply added: Me.Username = Forms!frmView!LoginName to my 'Add Call' buton code as outlined above. The button now sets up a new record, allows additions...

Thanks for the prompt response, DCrake, but unfortunately your solution on the username isn't going to work for me. I've already managed to implement the timestamp by attaching Private Sub btnAdd_Click() On Error GoTo Err_btnAdd_Click Me.Form.AllowAdditions = True 'I normally have...

Duplicated question. Please refer to the other thread for responses.

This sounds like you've got a split database, with the front end holding the forms, queries and other code, and the back end the tables. As rahulgty says, if you could upload the database to here, it will make it a whole lot easier to give you help!

Hi all, Just a quickie. I have a sub-form (frmLogs) that sits within a main form (frmView). The main form takes care of the client's details (say, Mr Bloggs), the sub-form (which has its client number field linked to the master form's client number field, so only shows data relevant to that...

Thanks, nieleg! I've gone down this route and everything seems to be doing exactly what I need. Thanks again!

Hi all, I'm currently building a small database for work, which will act as a call log for members of our organisation calling up for help. I'm pretty fluent in VB and reasonable in Access, but admit that I've never really had call yet to play with relational tables, so would greatly...

Apologies for posting here as well, but another thread I have spans a few technologies and it wasn't entirely clear where it should go. It's currently buried in what might well be the wrong sub-forum, so, rather than duplicating the thread in multiple places, I'd greatly appreciate it if anyone...

Firstly, apologies if this is the wrong sub-forum for this, but it's tricky to know where it should go, given that it spans a few technologies. Right, I've got a situation where work has asked me to write them a small telephone call logging application and database. This is no problem, and...

<slaps own forehead> A classic case of not seeing the wood for the trees. Thank you very much, Rabbie. Not only does the code work now, but, much more importantly, I've seen where I was going wrong in the first place. Thanks again.

I got you there, and use OpenForm VB commands myself with a lot of my databases, including this one. My issue is that as soon as the database is opened, frmLogon is opneed where the user gives their username and password. Once they click the 'Logon' button (and assuming their details are...

My thinking was along this line, but I posted as I can't seem to track it down in the help. Irritatingly, I'm confident this is a simple answer; I just can't seem to find it! Any pointers you can give would be greatly appreciated!

Hi all, Right, I'm currently in the early stages of building a multi-user database. My login code works perfectly, allowing me to setup as many users as I want in a table, plus passwords, and have those users login... ...what I have yet to get, and am having trouble with, is the ability to...

Hmmm...this is my preference as well, to be honest. Basically, they were originally asking for something web-based, but web-based databases aren't especially powerful in terms of the features you can write into them. With Access and VB I can easily deal with all the features being asked for...

You've precisely hit the crux of my problem. One office is on an SBS server and network, but the other is a small satellite office which has a small simple network and each machine has direct access to the internet. There are no shared drives, resources, or services whatever. If there were, I...

Hola, This is just - hopefully - a quick and simple question, but can anybody advise me of Access' capabilities when it comes to being connected to the web, or, even better, when linking tables to an SQL database stored on the web? Basically, I've been asked by work to look into the...

Hi all, I'm a relative newbie to Crystal, but seem to be making headway into building my own reports. I have run across a snag though, and would appreciate any advice on how to overcome it. I have written a report that lists a group of people from a table in my SQL database, in the following...

You might like to check my database from this thread. Here, I have adapted someone else's code to suit my database needs, and, instead of a password switch to disable or enable the key, I use a hidden button to give me immediate access. Read the post carefully, then take a copy and see if it's...

Hmmm...interesting. I'll try playing about with that, but I know as a result of testing that an interval of 50000 does indeed close my database after 5 minutes of inactivity. Thanks for your help, Robert88; I shall poke this a bit further to see if I can get it to run properly.