Search results

Hey, i've got what i thought was a really simple query thats proving hard for me to suss, search turned up no results. I have a query that has the following: First Name / surname / diabetic? / physical disability / learning dificulty /Other disability / apart from first name and surname...

Hi, I have a load of queries set up and a form that accepts building name, start date and end date, all queries get criteria from the form. I need a way of using the drop down box for more than one building i.e. an option of 'CANADA' meaning all buildings in canada. I figure i could do this...

Hi, I've got a few sub forms as datasheets imbedded in my main form. The sub forms contain information from other tables and are related to the main form with a primary key. Sometimes the sub forms will contain no records i.e if the client on the main form has no children there will be no...

Hi, I've been working on loads of queries for the past few weeks and have finally lost the plot. I can't get the simplest queries to work anymore, please help! I'm using Query by form but even replacing the form field with a static date I can't get the below to work. New Referrals 16-18...

Hi, I've seen people output data from an access database to an excel spreadsheet. This is not a standard export though this is exported to a custom sheet with totals etc. This would be great for us, I was curious how this is accompolished, it it through XML? We use varying versions of excel...

Hi, I would like to disable my 'next record' button if it is the last record in the set, this is to avoid the access error message 'can't go to specified record' i'd also like to do the same with my 'previous record' button on the first record in the set. i'd probably place this in the...

I'm having some difficulty getting access to do what I need, I have an overview form that uses simple command buttons to open other forms. when these other forms are closed I need any status changes to be reflected in the overview form, I can do this by using a requery on the onClose event of...

Hi, can someone tell me whats wrong with the below statement, DoCmd.OpenForm "ClientOverview", , , "[txtNINO]=" & [Me]![NINO] i've compared it to other ones in my database but with this one, access keeps generating the error in the title??? i've checked the field names time and time again...

Hi, i've got a command button on a form that automatically fills or changes textboxes based on the date and someones date of birth. Is there a way I can make the VBA affect all records at one instead of having to press the button on all records individually?

Hi, I have a lookup table which stores key words that we need to be aware of if they are entered in to the database. What I need to happen is if a word is typed in to a certain textbox or memo field that word is flagged if it appears in the lookup table, I thought about a dlookup statement in...

Hi, is it possible to create records and populate fields in another database automatically, we have to very different databases that serve two very different purposes and we would like one to be able to update the other, for example when someone adds a client on a database a corresponding...

Hi, I have a query by form set up, the criteria for my StartDate field is >=[FORMS]![STATISTICS]![txtSTARTDATE] AND <=[FORMS]![STATISTICS]![txtEndDate] it throws up the 'too complex to be evaluated message' i've tried using the BETWEEN clause with no luck, it works fine if i only...

Hi, is it possible for me to ensure that all new records in my form have a certain text box populated with the same information from the previous record. something like psuedo code txtclientInfo = previousRecord.txtclientinfo /psuedo code thanks

Hi i've got a couple of problems, 1st is it possible to reference a sub query in its parent report, I have severy queries in a report and i need to total the result of these queries (btw the queries count and only return a single number) was wondering how I can reference the sub query 2nd...

Hi, is it possible to link forms like they were SubForms? I have a button in my Client Form that opens a contacts form, it works ok but the clientID foreign key is obviously empty so there is nothing linking each contact to a client. was wondering how to get this to fill in when the...

Hi, i'm trying to run this in a command button as a filter "[ID]=" & Me![ID] & " And " & "ClientRecord.EndDate Is Null" there's no error or anyting but i'm being prompted to enter an EndDate when I click the button, I just need it to take me to the record where the EndDate is null without...

Hi All, I was wondering how to access a specific record where more than one dataset are associated with a record. e.g. A landlord keeping a record of tenants has many tenants who exit his premises and return a couple of years later. The landlord has a client table and clientRecord table, the...

Hi, I have a couple of tables Client and clientRecord. Client is linked to ClientRecord in a one to many relationship i.e. clients can have multiple records, I collect most of the information in a single form. In a second form I have a button that takes me to a third form that collects...

Hi, I have a couple of tables Client and clientRecord. Client is linked to ClientRecord in a one to many relationship i.e. clients can have multiple records, I collect most of the information in a single form. In a second form I have a button that takes me to a third form that collects...

Hi, I have a label that pulls some fields from a different form "LabelName.caption = forms.Client.FirstName" etc It works fine but I need the event to run when the user navigates to another record, At the moment I have it in page_load but it obviously only updates with the first displayed...