Search results

Hi, Bascially i have a calendar set up in my DB. The issue is that i now have 2 ways of where Bookings can be made. So what i need to do is get the data from both tables and fill the month calendar form to view. Is there a way that i can merge 2 queries? At the moment i have a single query...

Hi, Basically I have a transactions form, i have a trigger for after update. For the form which executes some query's and gives you the total. But the real issue lies in when i do a DELETE, because i cant get it to trigger the sub routine which stores the quereies calculations to run. So my...

Hi, Basically as the title says. Im trying to make a form where the sub forms records scroll across horizontally instead of vertical. Is this possible if so how? Cheers Tristan F

Hi, I was wondering is there a way to only QUERY day and month? dd/MM ? The issue is i need to build a report that has all the accounts opened within a certain month/time period. BUT its not year specific so i would need for instance. 01/02 to 28/02 dd/mm dd/mm Note: The date stored in...

Hi, Guys Im just wondering what the maximum number of simultaneous connections to an ACCES 2007 DB over a network,(obviously a mapped drive). I apologize if this is a double post.... Cheers Tristan F

Hi, Guys Im wondering is there a way to stop access saving fields automatically... Example you open up a form eg.frmEmployees (it has the employees details on it) You click in the address and change it but it was for the wrong person. You click close and IT SAVED IT AUTOMATICALLY :( Cheers...

Hi, Guys I'm building a simple time sheet database for a friend of mine. I know that im going to have trouble checking there amount against the tax table and taking there tax out to finalise the amount they would actually get. So basically im an intermediate access user, how would i get the...

Here is a calendar database that has multiple entries for each day.... Can't sort the entries by tiem on each day... if someone can figure this out and change it would be much appreciated... This was originally another guys calendar but was a little messy with the table, query, form namign...

Hi, Does anyone know how to use a rich text box in an ms access report and do formatting like 1 word bold the next one not and next line paragraph etc... Or how do i load a specific query in to a word document... The same as a report if you know what i mean... I need to have bold formatting...

To start with if your going to explain anything... lets just say im a noob.. :) I have a login form which passes the info to a sub routine in one of my modules... Option Compare Database Global MyStrUserId As String Global MyStrUserActive As String Global MyStrUserSecurityLevel As String...

To start with if your going to explain anything... lets just say im a noob.. :) I have a login form which passes the info to a sub routine in one of my modules... Option Compare Database Global MyStrUserId As String Global MyStrUserActive As String Global MyStrUserSecurityLevel As String...