Search results

The only thing that I have tried is to setfocus to the next field on afterUpdate and OnChange. I have also nullified manual entry of the date (as that causes problems) The vba (yellows out) error just tells me that I can't go to the field. I also wanted to populate an additional field Date5...

I have a bound form with four date fields. For brevity the user needs to input four dates. I have disabled the manual entry. The form opens with the focus on Date1 showing the datepicker. I want to: select a date, setfocus to date2, select a date, setfocus to date3, select a date, setfocus to...

Thanks Guys. Schoolboy error!

Im struggling to get this to create a message for the user. I have an import spec that imports my data to a holding table, checks that the data isn't already in the main table then adds if not. Private Sub Command0_Click() DoCmd.RunSavedImportExport "Import-AllocatedCash" ' I now...

Thanks Minty I'll give this a go and report back.

Minty I have put the Function into my database. How would I now "Call" it in my VBA code?

Hi Ridders. This is on a network and as such add-ons are problomatic.

I currently have several on errrors go to eg: IMPORTATN: DoCmd.OpenQuery "dltErrorLog", acViewNormal, acEdit DoCmd.RunSQL ("INSERT INTO tblErrorLog ( Errortext )VALUES ('There has been an error with importing ATN');") DoCmd.Quit These are used for specific parts of my code to...

Thanks PBaldy and Minty (did you see who I left out?)

Thanks Minty. I have just discovered "Views" which I shall experiment with. I think that the problem is that our network is incapable of processing data efficiently and the provider is telling us that it's an Access problem. Ten querys Five Tables Table 1 = 100k records Table 2 = 200k records...

Could somebody please point me in the right direction? I am converting my Access database to SQL and trying to replicate my querys. In one instance I have eight querys that rely on one another. Query within a Query Two questions: 1. Am I to assume that I would have to create nested SQL to...

Hi Mark Thanks for your response. The issue with <FILE TO IMPORT HERE> is that the file name will change. (See original point 2) what I need is: DoCmd.TransferText acImportDelim, AllocatedCashImportspecification, tblAllocatedCashImport, <FILE THAT IVE JUST SELECTED >, 1

Thanks Guys I was being dumb and figured it out. However my imports are csv files not a spreadsheet. I have saved an importspecification Could you help with the correct way to import a csv. I've tried to follow the website and got this far but it pulls an error. DoCmd.TransferText...

Hi Ranman Thanks for you time. I have placed the Function into a Module but I am unsure what the "usage: vfile etc " is? Could you help further? I'm afraid my VBA is somewhat basic. I have Microsoft Office 15 Object Library installed as a reference.

I've always struggled with this but never pursued it. 1.I want my user to press the cmdbutton. The window directs to a specific folder on my computer. 2.The user selects the csv file (could be named anything - usually date orientated eg Income 2018.csv) 3. The file is uploaded the window...

Thanks Gasman I can get that to work on the OnChange of the specific Fields within my SubForm but it doesn't work on the SubForm's On Data Change event !!

Thanks RanMan I started to go down that route but I'm struggling to reference the cmdbutton on the parent form. Basically if a change in SubForm1 Then ParentForm.CmdNextButton.visible = TRUE

I have my form with sub forms and wondered if there was a quick fix to see if anything has been changed (on either the main form or sub forms) The reason for this is that I want to create a MsgBox that states "You haven't submitted any changes" I have tried "On Data Change" but this doesn't...

The holder solution worked. I created a single form then attached my continuous form as a sub form linked the relevant data and now open the "Holder" form from my main form.

I have a (Do not display) Tabbed Documents database. I would like to open a (pop up) continuous form to my desired size auto centred. I've tried Private Sub Form_Open(Cancel As Integer) Form.WindowHeight = 5670 Form.WindowWidth = 5670 End Sub But it tells me that this is not updateable. I...