Search results

Try this http://www.access-programmers.co.uk/forums/archive/index.php/t-77492.html

Indeed. Not so long ago, I was in a similar situation to you, emandjam (viz. I believed my Access skills weren't up to creating the kind of databases I wanted), but what I found the most beneficial - as well as being a member of these fine forums, of course - was to get hold of databases that...

Should be as simple as a few lines of VB code to check the status of a client (record) is high upon the record being accessed. Can we just clarify, is there an actual box on your standard form that contains the status (high, medium, low) of the client?

Not to sound trite, but you might also want to double check that the actual database MDB file isn't currently set to 'Read Only'.

You might well need to update your database references to get this coding to work. Just enter the VB Editor, then select Tools, References, and make sure your list looks like the one in the attached picture.

Not really. People of pliow's unique intellectual capacity rarely get the chance to be in a position to ruin things for the rest of us. He'll trundle off when he doesn't get attention. Back on topic, have you considered using VB script to assign field names to bookmarks on a Word template...

Just tried your code and ported my search engine double click into the new form, everything works perfectly now! Thank you, very very much macca!

Ah, good idea, macca; will try coding that now. Don't worry about the double-clicking, I already have that fully functional in my search engine, so will just port the code across. If you're interested, I use the following as the 'OnDblClick' event: Private Sub NAME OF LISTBOX_DblClick(Cancel...

Ah-ha....works perfectly now. Thanks a lot, macca, sincerely appreciated! Any idea on the answer to my main query, out of interest?

Um...I think so. My table, 'maindata' is sorted by the primary key, ID. The column in question is called 'rmaclosed', and contains a date if the case has actually been dealt with. What I need, is for this counter to look at that table and simply show the total number of records that do not...

Sorry, macca, but I don't quite follow you. I have created a list box, the properties of which can be seen in the attached image. When run as a proper form, said box is just blank, despite the RowSource containing the code you mention. What am I doing wrong?

Hi all, Sorry if this has been asked before, but I've used the Search function and can't find exactly what I'm trying to achieve. The Current Setup I have a database that I'm now trying to expand upon by adding extra features. One of these features I'd like to add is the ability to...

Indeed. The only way I can think to do it is have the splash screen written in something else and saved somewhere on the PC as an executable file. you could then have Access run the .exe

Ah-ha! Ze saving, she works! Thank you, very much, JTB; your help is greatly appreciated.

Thanks for getting abck to me, JTB, but I'm still running into trouble here. If I modfy the top of my code to: Dim WordApp As Word.Application Dim strTemplateLocation As String Dim strsav As String strsav = "THE ABSOLUTE PATH OF THE FOLDER WHERE I WANT TO SAVE" Then add the...

Ok, rather than us just bouncing posts back and forth, it may be easier for you to take a look at my actual code and see if you can tell where I'm going wrong. Here is a copy of the complete database - minus all the big images and private data - with a couple of test records setup to show how...

My table format is 0000000. I have two forms, one for viewing and one for adding. the viewing form displays the 7 digit RMA numbers correctly; it's the adding form that is having problems since it autofills the box with the last RMA number + 1 (correct), but is only 6 digits long (incorrect)...

Sorry, but can anyone help with this final query, please? I really, really, need to know how to have my script autosave the opening document to a certain folder, under the arguments "RMA_" WHATEVER IS IN THE RMANUMBER BOX "-" WHATEVER IS IN THE COMPANY BOX ".doc".

The 'Default Value' of my box is currently: =Format(DatePart("m",Date(),"00")) & Right(Format(DatePart("yyyy",Date(),"00")),2) & Format(Right(Nz(DMax("[rmanumber]","maindata")+1,1),2),"000") This works, but chops the first 0 off the number (as I mentioned before). If I change the last part as...

Sorry, MStef, but I just get an #Error when using the vb you quoted. I can see why; it's because it just appears to reference the cell in which the autofill number should appear, and doesn't seem to make provision for checking the table for the last number. Unfortunately, the 'Default Value'...