Search results

i'm trying to get a query to filter off a form's control value

hi if i have a filter that says IIf([forms]![frm_Reports]![optBusDay],#19/08/08#,"*") what's the syntax to ge the * to work?

what's Cupidrst?

hi if i have a query that has an outer join in it and then a Dynaset (Inconsistent Updates) form on top... then you add a new bit of data on the (unpopulated) outer side of the data and it looks fine in the form but what it actuallly does is create a new record with a blank field (instead of...

can't get that to work...maybe it's me being thick, i'm certainly no MSDOS expert?? net rpc anything leads to the help message about net...:confused:

anyone know the MSDOS to see the nested groups within a usergroup? using get group abcgroupname /dom gives me the usernames, but not nested groups :(

you don't pay double tax, your company either employs you as PAYE (sorry an UK here!) and takes the tax off for you and asks for a bank account, or they ask for a company name and don't deduct the tax, leaving it to you if you stay director of a company, your new employer may well stipulate...

Access developers earn about £200 a day, more in London, even more for banking and yet more for front office 200*5*4*7=£28,000 that would be if you were on the payroll and you weren't as for how much you should charge...easy, as much as you think they will accept ;) how many users will...

long story, i'm moving back for a girl

no, fair call: it's not condescending, it's constructive criticism ;) it's a trade off between less lines and less calls: i prefer the odd dlookup instead of all the bumf of the obect variable maybe having so many dlookups would mean switching to recordset...i kind of started with two and it...

you should use the debug window when the code debugs and type ?sQuery then copy and paste this into query design and see if there's any faults in the SQL you'll find yourself doing that ALL the time :D

ha, i;ve solved it the changing of the source object means that it guesses the linkage and it always guesses a one-field link and it doesn't let you change one side of the link to two fields if the other is one but you can raze them and then change them so Sub FormatGrid(strType As String)...

oh sorry i have changed it since :) the second one is Master

aaah error 2335 in this code:- Sub FormatGrid(strType As String) Dim strHeaders(1) As String Dim strSourceObjects(1) As String Dim strChildLink As String Dim strMasterLink As String Const GUITABLE As String =...

ha you work in the exact spot where i was born :) PM me if they got any jobs going and need an Access guru, i'm moving back next year :D

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp there's lots of stuff to learn i'm afraid you can also switch everything off: f11, background tables and the shift key (with code) and enable the shift key on log in, but switch it off when logging out...

:D:D:D that one's bitten me on the arse a few times

how about Public Function FileExists(strFile As String) As Boolean If Dir(strFile) <> "" Then FileExists = True Else FileExists = False End If end Function

funnily enough the only time i've ever used a class module was when i was translating data into Excel workbooks, complete with graphs. I created an Workbook object that had sheets and graph collections and properties of graphs before creating Excel stuff in Excel itself

is it me, or is there rarely a need for class modules in VBA? or arrays for that matter... if i need an array or an object, i represent it in a table and work with that perhaps i'm sticking to what i know, but can anyone tell me where they used a class module because it was by far the best...