Search results

hi folks, its been a while since I posted, mainly as my organisation is trying to move away from MS access applications. Anyway, here's my problem, I tried to deploy and Access database to a number of machines. these machines didn't have Access installed, but rather a virtualised client. The...

HI all been a while seen Ive been on, mainly cos Ive moved away from Access. Anyway, onto the problem at hand, Ive been sent an .unv file to upload to our BOXI server. Now Ive been doing a bit of digging on the web but most searches that are being returned are about importing excel documents...

IM doing a simple data entry form for an excel sheet. I have 3 text boxes. txtID, txtRefDate and txtSeenDate and Im using the following code to add data in a new row Private Sub cmdAdd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("RefData") 'find first empty row in database...

Hi folks been trying to get my head round this one for a while, and I seem to have hit a brick wall. Im looking to get the number of bed days (overnight stays) from my database. Ive used a query I found on here to get the number of nights based on a start date and end date. StDte and EndDte...

Hi Folks Im currently building a system and part of this system requires a report/query that sums accommodated nights by clients in certain establishments (not those type of "establishments") by month and by quarter. Previous systems that Ive done, which do similar calculations have been based...

A bit of a general request for info and a bit of a warning to be heeded. OK, Ive been using 2003 for some time now (quite happily I might add), only to be told a month or so ago that we were getting upgraded to 2007. The first problem here is, not every dept has got the upgrade so we have a...

OK, I got Access 2007 forced on me recently, IT updated but I couldnt make changes to my 2k3 files (.mdb) without a massive headache, SO after much fighting I eventually got them to install 2k3 again. The problem I have is that the system IM working on keeps telling there is missing references...

Im having a little trouble referring to a control on a parent form as you can see from the code below, in particular the setfocus line Private Sub cboPrim_Reason_AfterUpdate() If Me.cboPrim_Reason = "Mental Health - Other" Then MsgBox "If you select Mental Health - Other then you...

is acting really weird 1) Space - when trying to type a space in the code, the space appears momentarily but then goes back to the orginal position (ie press space bar it jumps forward and then jumps back a split second later) 2) Code is always appearing red as I type in code, as if its in a...

Anyone used the module for scaling forms? just want to know if this needs to be applied to all sub forms as well as main forms cheers

Hi Folks doing a bit of skip logic an TBH I thought it would be straight forward until I hit the following problem. Say someone selects an answer from a combo (say Yes or No in this case), yes in the after update locks down/disables the comment box underneath said question and sets focus to the...

Small problem that I though would be straight forward, but sods law kicked in and Im at a loss What Ive got is a main form that has 13 buttons that open up another form for entry/edits, what I want to do is indicate via a checkbox on the main form if there is already a record and thought this...

Just wondering if anyone has deployed an access database on XenApp, is there any pitfalls I should look out for. Actually truth be told its only an MDE front end, as the backend will be on SQL server. Still any previous experience of deploying on metaframe would be gratefully recieved cheers...

Hi Folks Just a quick question about linking composite keys for my composite PK I have autonumber and a static txt value, so my question is do I need to create both of these fields as FKs in the other table and link both fields via the same method as a normal 1-many relationship?

Hi Folks Im looking for some pointers with a small problem that has just arisen while trying to use check boxes on a form. What I have is a number of check boxes on the form (15 to be precise) that look for obviously check for true or false values within the data set. These check boxes...

Hi Folks got a small problem which Im sure is pretty simply, here's how it is I have a form and on the 'On load' event it has an IF statment which checks via DLookup to see if the PK exists in another table, if it does find the PK in the other table it opens another form which I would like...

Hi Folks Working on pulling through a record field (from a previous record) into a new record. Ive seen plenty of examples of this using DLookUp but they dont show what I actually want to achieve, so any help or pointers would be gratefully received. Here's what I want to do. I have a table...

Hi folks Having a small problem with IIF. I have a query that calculates a persons age using datediff, Im then required to put these into age bands. So i thought I'd use and IIF statement to check the calculated field and then for it to specify which age band it is in. Problem is as I see it...

HI Folks looking for a little help in passing parameters from a form to a report which has multiple sub reports. Ive seen a few articles on how to pass parameters from a form to a report which has one record source but cant seem to find any demonstrating how to pass parameters from the form to...

HI Folks Ive got a form which lets the user input parameters for queries/reports. Now this works fine with standard SELECT queries, but I cant get it to work with crosstabs. The crosstab query tells me the fields are not recognised (even though the criteria in the query is the same as the...