Search results

im wondering if i could use openargs for this instead, but not sure exactly how to do this with 2 forms and 2 subforms.

but i need to display not only the correct person in frmRIAProcess, but the correct application in the subform frmRIAApprovalRequest. the parent form doesnt have a control called StandardLetterID only the subform the field that links both parent forms with both subforms is PersonID, does...

Hi , i know this will be really easy for someone here, but im struggling to get this working. I have parent form (frmRIASelectApplication) and sub form (sfrmRIASelectApplication) . The subform is a datasheet. I am creating a dblclick event on the Control StandardLetterID of the subform. I...

oh, it's working now! Thanks!

sorry just noticed that and amended but still comes back false

thanks for your help so far!, i think it is getting there but now have a runtime error 5174 File could not be found (C:/windows/system32/False) for some reason when i debug mypath3 it returns False here is my code now: Dim mypath As String Dim mypath3 As String Dim Wordpath As String Dim...

o wondered if maybe it was because i was using an old word doc, so i converted to word 2010. I cant seem to get the syntax right for mypath3, i'm assuming i need a " at the beginning, but keeps coming up with syntax errors if i put it in the string.

so, i take it it needs the " around as there are spaces in the file name?

ah i had to put the " at the beginning to make it work.... penny is dropping

hi i've remmed out the setwarnings (this was still in from a maketable query that used to be in the code) here is the result from the debug: debug.Print mypath3 C:\Documents and Settings\krowe\Desktop\Access 2010 citrix version\Housing DB local copy\merge test.doc" which is pointing to...

Hi I'm upgrading one of my databases to 2010 (front end only). In the 2003 version the code for running a mail merge works fine, but im getting a runtime 91 error - object variable or with block variable not set. here is the code i'm using: Dim mypath As String Dim mypath3 As String...

i have this sorted now, i found out a way to start my indexing on thetblPerson on the new database at a higher number (i will start at 50,000). I can then append the old records without conflict. The the related tables will be fine too as it doesn't matter if their unique referneces change, so...

There is a lot of bad data that will cause problems with another database I am linking too. Id rather start with a clean sheet and pull data across if and when I need it, cleaning up each record. Otherwise I have 1000's of records to check and clean and only 3 weeks to do it

Hi I have a database that i need to archive and start a fresh as i'm integrating with some other software. My plan is this: 1. copy database AdviceDB back end and rename ArchiveDB 2. delete data in AdviceDB back end 3. copy front end and link tables of the new copy to ArchiveDB so i will...

Thanks, that make a lot of sense now, wish i was experienced enough at all this to be able to work out a solution like that

Thanks for your helpful post I am very much an novice (hence being on here all the time asking basic questions like this!) having had no training in Access and being completely self taught. I take your point about the naming of the boxes, and will change them to something more useful in...

hi hope you can help me, I have a table with date/time field in. I have a date entry form with a 'from date' and a 'to date'. I have a query that uses the form a criteria to selct the date range, however I need the query to return only those entries received between midday the first date...

ok, sorted it, just notice my clanger allowedits is not allowdeletions!!!! thanks for your help

Hi Thanks for your help so far. I now have this code on the onload event of frmMain: DoCmd.OpenForm "frmPassword" If Forms!frmPassword.Password = "edit" Then Me.AllowDeletions = True Me.sformCasenotes.Form.AllowEdits = True DoCmd.Close acForm, "frmPassword", acSaveYes...

thanks I am now making progress with this on my password form i now have this code: Private Sub Command2_Click() If [Password] = "edit" Then DoCmd.OpenForm "frmMain" Else MsgBox "password incorrect", , "Password Incorrect" End If End Sub I have put on the OnCurrent event of...