Recent content by jasn_78

Galxiom, basically in the database I am working with (which is a 3rd party db) I have on each product a department, subdepartment and group. I wish to be able to choose more than one of any combination of these and then use these in my report options. At the moment I have these listed in...

I have a series of seperate forms that all my main forms refer to that allow the user to choose a choice between specific departments, subdepartments and groups to filter the report by, now at the moment I am storing this data in a query that is created once the user has chosen their options. At...

Nevermind guys, didnt realise there was a weekdayname function :)

Ok guys I have narrowed it down to the formatting of the Weekday value back to a name, so instead of showing 1 I need to show Sunday etc when I take this out it works fine on the users p.c but when i add the format command back in i get the above error. Any suggestions?

Sorry guys any1 got any ideas?

I have the following query in access which works fine on my computer but when i package it into an accdr with access 2007 runtime i get "Error 3075: Function is not available in expressions in query expression" Any ideas? SELECT fe.functions AS who, e.trxtimedate AS clockoff, e.trxtillid AS...

thanks mailman, sorry for all the questions just trying to follow everything :) the only other question i have atm is when you say change the date to a dateserial value what will happen if i change from access at a later point as im trying to learn .net as well atm so cant see me sticking with...

Thanks mate will have a look at all your suggestions, couple of questions. 1. When you say update every ten records or so at a time the reason I am using the dmax function is to make sure that the salesid I have in tblSALES is the same used in my other tables when inserting the data in those...

namliam: now i know this is once again opening an old thread but figure its on this same code so better than asking in a new thread. Everything is working pretty well except seems to be running a bit slow on text files that are over 500kb in size, is there any thing else i can do to improve it I...

Gizmo, with the people this is for you def dont want them having to do more than is neccesary so trying to integrate all the steps into one button. Thanks

Ok not sure which section to put this in but is there a way of copying from windows to a mobile device without synching? or the other option is exporting the csv straight from access to the mobile device Thanks Jason

thanks hitech coach it is that cant figure which reference atm but removing the format command from the query has fixed it

Hey everyone I am having some problems on some pc's with a form and a query, it all works fine from my pc but not on ones where I install just the access runtime Attached is an error message I am getting when i install this database on any remote computers below is the code which is causing the...

mailman ok so nearly final product on this code. Public Function SALES(Journal As String) FileCopy Journal, "C:\TFRS REPORTS\AJ1.CSV" Name Journal As Left(Journal, 21) & "old" DoCmd.TransferText acImportDelim, "aj1import", "tblAJLTEMP", "C:\TFRS REPORTS\AJ1.CSV" Dim db As DAO.Database Dim...

namliam, yes that is to include payments, and sorry i wrote that wrong it is meant to be current(0-30) 31-60 61-90 and 90+ hope that makes more sense