Search results

I have done something similar in MS Access 2007...this maybe a little rough: 1. Open Access and your database 2. Click Database Tools 3. Click Database Documenter 4. Click Tables - Select All and Click OK 5. A report will be displayed, save this to .txt or something 6. Open .txt file (which...

ID Name Score Phase Appealed 1 bob 101 1 No 2 bob 50 2 Yes...

Hi, Its been a while since I played with Access and I am helping a colleague out..unfortunately not very successfully at the minute. We have a query that returns 5 columns from a much larger table. 1 column is titled "phase" and is one of three options. Another column is "appealed" and is...

ok I have it sorted - sql below. New problem is this doesn't account for date/time fields....bah...I am not going to spend anymore time on it as it probably isn't worth the hassle. However if someone knows a quicker solution than all this please let me know. Don't know how I missed it...

Hi, I have a database I am working on, I need to compile a list of populated columns in each table. Some tables have too many columns to do it manually and I am hoping someone may know some SQL to help me. The DB is held in SQL Server 2005. I have the following SQL which does part of the...

Thanks, I ended up with the following - refresh/requery didn't cut it. Dim objFSO As Object 'Create Instance of the File System Object Set objFSO = CreateObject("Scripting.FileSystemObject") 'Source file, Destination folder (must end with a backslash \) objFSO.CopyFile...

thanks, I actually just implemented it and it works fine. Now to find a refresh form one (so after the files deleted the form is refreshed to show it)

Hi, I have a form that imports all the contents of a directory into a table. I can then view and open these files - most of this came from a sample database provided by this website - much obliged. The form displays all the contents of the directory with a button to open the file. I would...

if you need better integration into a website, ask here again...i am relatively inexperienced with that and there maybe an easy way...

which version of access are you using? MS Access 2007 (and probably 2010 although I can't confirm) offered a Data Collection tool for use with emails. http://office.microsoft.com/en-us/access-help/collect-data-by-using-e-mail-messages-HA010015427.aspx Is that what you mean?

haven't done this myself but hopefully these links are useful: http://www.4guysfromrolla.com/webtech/042599-1.shtml http://www.w3schools.com/ado/ado_connect.asp http://www.webwiz.co.uk/kb/asp-tutorials/connecting-to-an-access-database.htm

good man, add "nucl34r panda" on xbox and ill give you a game/play with you.. i mostly play reach these days..but do quite well normally

Hi, I am developing a simple database to improve the effeciency of a client's job. Anyway I decided that the greatest level of effeciency can be acheived by allowing a "secretary" to update a calendar of a sales orientated person, who can then access that calendar on the move. I was going...

whats difference?! hopefully not pedantic

can you install 2007/2010 on your machine and convert your database to a more recent version. you could split your database and retain the back end in 2003 and the front end in Access 2003/2007/2010...

It is USB v2. Transferring to a flash drive is bas - that is down to the to flash drive though. However even transferring files to an external HDD i expect it to be faster - at best I get about 75m/s. When transferring 100's of GB it gets frustrating. I think 1 problem is my card reade - i...

hows your indexing?!

Hi, I think this is a pretty prevalent problem but has anyone found out what causes the USB transfer rates to be so slow and if there is a fix? I generally end up transferring data via usb at less than 10mb/s

I can list a few here but unfortunately I may get fired. I don't particularly enjoy using Progress.....

sorted - FYI - I took out broken disc and set PC to boot to CD - then install Ubuntu followed By Windows onto the good disk. This worked a treat :P