Search results

I have a table that holds 250 records, and dont really want to split manually as the saving grace is that each record, has a hyphen that marks the point where the split needs to take place. For example, the field currently holds 'Movicol sachets - 1 or 2 sachets dissolved in water at 21.30'...

It would also help a great deal if you put any tables that get used for populating combo boxes etc in the front end if the data doesnt change. For example, we have to record a clients weight. We work here in Stones and Pounds, but I found it hard to record that weight in access. So I made a...

On my portable appliance testing database, I need it to show me a report so I know what is due for testing, as some appliances get tested/inspected more frequently than others. The way I do it is have a test date, then have a field for the item that has how many days until it requires another...

I have trawled through the samples, and cant seem to find what you say look for. Do you recall which sample has the clues I need? Thanks.

Indeed! Off topic I know, but the trouble with the inspectors is that there are no hard and fast rule of do they have this, yes, do they have that, no etc. Wether or not we meet the standards and regulations is all down to the individual inspectors interpretation of the standards and regs, so...

We have to record deaths is a particular way, but for people not savvy to the regulations governing care homes think of it as an accident book. If anyone has seen one and/or filled one in, you know there is a great deal of information it does request. Some of it might not neccessarily be...

Thanks for the replies. I am not too concerned about there being number gaps in the table for its record id's, it more a case of ensuring that there is data in the fields where data is being inputted which is more of a concern. For example, we have to record when there is a significant event...

OK, I thought I had explained it enough. Although some seem to think I am barking mad, and given my head is full of cold, you are probably right. The form is intended to be filled IN FULL before the changes can be written to the database. It is to ensure that the record is saved all at once. I...

Are the PC's that are experiencing the problem, working otherwise OK within the database? My thought here is that somehow the 'mapping' to the data file has got corrupted, or users have changed a network drive, that should point to f:\clientdatabase\h_dat.mdb, but the drive map has been changed...

What I want to do, is have an unbound form, user enters data in to it, then clicks on a 'save' button which then writes the data to a new record within a table I have got no idea what it is called so find it hard to do the search.

LOL, that has happened so many times! And then I end up kicking myself as it was two words that needed swapping round, or I had inadvertently typed a comma instead of a full stop, the end result is I cant get back to sleep as I cant stop thinking how easy the solution was!

My first idea would be try creating a nice blank access 2003 database. Then import all the items from the old one in to the new and see if that makes any difference.

I would like to share my thoughts about the community here, as a VBA novice. :o Some of you might think I am one of those that you 'spoon fed', but I hope not. I have on occassion made a post after trying to find a solution to a problem for some time, then to only find it once I have submitted...

LOL Just watch out for the packets of cigars that might have broken open, they might not seem what they are. Nothing quite like a beach cigar!

I use this code for doing the same kind of thing. You can drop the word bits out, but it should be clear to see what you need to do. Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to print the cover?" Style = vbYesNo + None + vbDefaultButton2 Title = "Service Users...

I like the sound of number 3 Doc Man, that sounds great at the moment, havent worked out yet who the target is, the owner or my colleagues! This is actually a helpful thread to me, so thanks, I have just used the hidden form method.

I have sussed it. Finally found something, just as always after one posts the question, the very next click you find the answer. This is the code that now works If IsNull(Forms![frmclientmain]!subfrmDocuments.Form![DocumentAddedDate]) = True Then...

Because on occassion the document may be moved about on the server and then the date would be a new date, not an old one, and it needs to be the date the document was originally put on the system. Hope that makes sense.

I have a main form, which has a subform on it. THe Main form is the main page for the clients, and the subform holds hyperlinks to PDF files (letters we have recieved on a client). This works fine. I am trying to get it so when a document gets inserted in to the subform, a date is...

I have the need to make clients inactive, they leave us but we still need to hold the information for the authorities, so to stop them being deleted, we just make the record inactive. Remember to make sure you have the neccessary field set in the table/form to put the date. It checks to see if...