Search results

Cracked the first bit: Between DateAdd("d",-30,Date()) And Date()

How can I make a graph show the last 30 days. I have a continuous form that allows the user to fill in a date field and a weight field. The graph in the forms footer shows the all of the information, but obvisley looks clutered as it shows everyday regardless if you put in a record on that...

How do I reference a specific worksheet in an excel workbook. This is part of a restore process that I am doing. My code is below: Dim sSource As String 'The name of the file to be copied sSource = "c:\Gundog Training Databases\BackUp\" 'Ask if you want to overwrite it If...

Hi, looking for some help with a string. I have populated a combobox with a list of file names by getting it to look at a directory. When I choose one of the files, the name is put into a text box, (me.BackUpName). I also have a btn_Restore, I now want to copy the file and restore it to a...

Thanks had to change a bit as Im using 2010. Where youv'e written 'Scription' should now be 'Scripting'. Thanks again

Is it possible to populate a combobox with all the files named in a particular folder?

If Im changing the front end, the records will remain the same or if the user reinstalls on a different machine.

Having split my DB, I have now made a button that backsup/copies the BE to a backup folder. It copies the database name and puts the date of the backup on the end (GundogTraining_be 18 01 12). What I need to do now is create an Import function. Where the user would select the button which...

I have recently split my DB but now want to add a new table how do I link it to the DB with forms in? Thanks

OK, but right now the DB isnt split so do I have to stipulate which parts of the DB to copy or should I leave the buuilding of this until I have split the DB

Its not going to be on a LAN its on a numbe rof individual PCs holding information about their own dogs. I appreciate that I could copy the whole file, but I only realistically need the tables in order for the user to import the data after a potetial update. Im also reading from other threads...

Could someone give me some advise on Backing Up data. My intention is to split the database, but want the user (single users) to be able to backup their data to a memory stick so that it can be resinstalled on a new PC if required or if I should create an update for the software. Should I back...

Chris, thanks for this, it makes a whole lotta sense to me now, (havent got my head around the link yet!) The concatinated field is a join between a date field and an Event Name, so yees the user does put that info in, but ot only concatinates once the name is in. The only issue I see is if...

Didn't like this bit: Shell EventPhotos & Me.ConcatinatedName Coming up with a file not found error

Sorted, how does this look? Private Sub btn_EventPhotos_Click() Dim x As Variant Dim EventPhotos As Variant EventPhotos = ("C:\Databases\Event Photos\" & Me.ConcatinatedName) If Len(Dir(EventPhotos, vbDirectory)) = 0 Then MkDir (EventPhotos) End If x =...

Thanks Chris, first time ive doneanything like this, co how would I define it as a vaiable (bear in mind I get most of my code from cources and then adapt it, so dont always know what the code means!)

:o Doh! Thats what comes of working at it till 10 at night! :o Should read: Private Sub btn_EventPhotos_Click() Dim x As Variant If Len(Dir("C:\Databases\Event Photos\" & Me.ConcatinatedName, vbDirectory)) = 0 Then MkDir ("C:\Databases\Event Photos\" & Me.ConcatinatedName)...

Sorry but your link dosen't appear to take me anywhere

I have been playing aroiund with some code to open a folder, first it has to check to see if the folder exists, if it dosent, it has to create it. It works fine up to the point of opening the folder. When it opens it always opens My Documents rather than the path that I want. This is my code...

No problem, thanks for taking the time.