Recent content by sarah_anne

Workmad, thanks for your input - however the server I am working on does not permit SQL execution of statements (.execute)! Found that out after a couple hours troubleshooting :rolleyes: I have figured out a way to insert using recordsets, however, but am having different problems... it's...

Lol, done. Three times. On three different disk drives - and am making it a routine come 5:25pm that I back it up to those locations daily! :D :cool:

Of course, I'll explain... We have a main database that's edited using the intranet with ASP pages. However, the data needs to be edited offshore (literally onboard ships with no net connections) and they aren't happy using CSV files, they want to use Access forms as they're familiar with that...

Hmm. Having considered I think I may have placed this in the wrong forum, oops! I'll leave it at the mods' discretion on this one :)

I have a main data-filled database with a table called "aTable", as well as a secondary empty but structurally identical database. On my ASP page (export.asp?ID=[id]) I can open a recordset containing all records from main db matching that URL parameter; let's call it rsData. I would like to...

Couldn't delete the access created file initially, but when I restarted my machine it disappeared. Tried copying all of the db objects over to a new mdb file (long painful process) and this seems to have worked. Fingers crossed I won't have to do anything further. Thanks! ;)

I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error". I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in...

You can set it as a form background, rather than just an object on the form, by opening up form control (double click the little square in the top left corner of the form), under the Format tab is the 19th (on my machine) field down called "Picture" where you can browse to find a pic. You can...

Just discovered that my method does NOT work if there are no previous records in the table, should have been obvious but oh well. I've tried using the DefaultValue setting in the textbox's controls, and the Expression Builder pops up. I specify the table/field I'd like to get the default...

Doesn't matter, it's as simple as what I've shown below (thought I'd best post up the solution here in case anyone needs this for the future!)... In the BeforeInsert event: DoCmd.GoToRecord , , acPrevious ' going to previous record Dim vid As String ' declaring a variable to store my...

richary, it seems to be working, thank you! :) :D Right, off to fix a problem with my access forms and then read up on these brain scanners before lunch, should make for interesting reading, eh? :)

I have a form where all records are listed on one page with a vertical scrollbar (all simple textboxes): ---------------------------------------------- PrimaryKey Name ForeignKey ---------------------------------------------- 1 Pam...

:D I figured it'd be a breeze just to use MsgBox FileDateTime("VesselConfiguration.mdb") ... obviously not that simple. I've done a search (several) here, on google, on other Access forums I've found... nothing... even MDSN no help! This can't be an odd thing to want to do -- when...

lol no, I mean the file I want to know the file properties for IS the file opened in MS Access! I.e. config.mdb has a form in it. When opened, I need to display when the last time config.mdb was modified. I can do this using FileDateTime, BUT only if I know both what the user has called the...

Thanks guys! :) :D I'd still love to know how those numbers correlate to anything in computing, so if anyone's got an answer just for curiosity's sake, do tell as I'd love to find out! :D