Search results

Hi, I've not done many reports in the past so Im a bit of a novice. Im having problems getting fields from 3 differnt queries into my report. Now the first problem Im having I think is something to do with the fact that these 3 queries are created from one other query. Basically I have a main...

Hi Everyone! Is was all going well till this morning and now its all gone wrong!! I have a table full of bank payments. This table is updated from a spreadsheet, which is made from an Internet banking statement. So basically every month I import the spreadsheet into the database updating...

Hi, This one sounds really simle but Im not sure of hte best step forward. I have a membership database. Everytime we have a new member we enter the date the member joined in a simple short format. So for example Joined Date 1/1/2008 4/1/2008 10/1/2008 3/2/2008 6/2/2008 I would like a query...

Hi Guys, Not quite sure where to start with this one so I need a little help. I have a main form which is split up with tabs which all contain subforms of various different forms and queries. I have attached pictures for clarity. On Pic1 there are two subqueries. Pic2 shows the subform of...

Hi everyone, I have a very confusing problem that im not sure where to start with. I have table that contains members payments. This table is updated once or twice a month with all the new payments that we recieve from the bank. This table contains the date of the payment 'datepaid'. I have...

Morning everyone! I have a little problem Im sure you can help me with. At the moment I get a spreadsheet from the bank every month which i import into our database. At the moment I do this on the last day of the month first thing in the morning to ensure there are no duplicates. I was asked...

Morning! I remember doing something like this in college years ago but I have no idea what its called to search for it. I have a piece of code that I want to repeat a few times but I dont want to just copy the code 4 times over. I would like to know what its called when you write the code you...

Hi, Im using some Visual Basic code Ive cobbled together from this site to export some data from access to word using bookmarks. The code I have used works great apart from one little problem. If a field is left blank, which in some cases it will be, then I get a 'Type Mismatch' Error. This...

Morning! Can anyone point me in the right direction. Im looking for a web page or help document somewhere to explane how to do bookmarks. All I need is something that will help me export the name and address of a client from the data base into a letter in word atthe click of a button. Ive...

Hi guys, I have a problem. I have 2 forms, 'frmClassList' and 'frmDailyCash'. 'frmClasslist' contains 7 records, monday to friday, with the classes that are on that day on each record: clDay / Class1 / Class2 / Class3 monday / Aerobics / Spin / B&T tuesday / Pilates / Tone / Circuits...

Hi, This is a simple problem but I cant seem to find the right code to go with it. I have one with one field and one button. What I want to do is when the button is pressed a new record is created (done this part already) and the date is automatically filled into the date field. This is the...

Is there a way I can disable the middle mouse scroll wheel from flicking up and down records? I have a main for with client info on and when i click a button it opens there bank info form. the problem is there will only ever been 1 bank record. Ive taken the naviagaion buttons of the bottom...

Hi everyone! Ive had a search through the forums and I cant quite find the answer to my question so here goes. I have a membership form which displays all members information. On the form I have a header which contains a few buttons to do various things and I would also like to put on there a...

In my query Im using the criteria ="cashpayer*" to bring up any records in this field which start with cashpayer but its not working. Is my text correct? Cheers Phill

Hi, I have a problem with my query. I have a table which has a record of payments, the fields are id/datepaid/reference/amount My first query works fine. its simply to find the payments between two dates. The criteria is Between [Enter Start Date] And [Enter End Date] which is under...

Hi everyone, This is so simple but I cant get it to work for some reason so I'm probably over looking something really stupid. Ive got two forms, one 'Members' and one 'Paymentdetails'. On the members form I have a button which when pressed should bring up that members payment details. This...

Hi, Ive got a small problem in a form on my database. I have a main form called 'Members' which stores details of all our members. With in this form I also have a subform named 'Payments'. There is a relationship between the forms Membership>Description and Payments>BankDescription as one to...

Hi, Im putting together a membership data base. the data base has an already existing client base which all have membership numbers in the form of first letter of there sir name, last to numbers of the year and a 4 digit number. So for example Joe Bloggs membership number would be B06001 his...

Hi, Ive come up against a brick wall once again in my database so once again here we go. I have my main from Members which contains a field traffstatus, this field will be filled in with either Green, Amber or Red. Green is some one who is up to date with there payments, Amber is someone who...

Hi, Ive never used the security in access before but I have designed my database and have used the security wizard to set my security. it has now put a shortcut on my desktop which is now used to open the database. The problem is that now I need the database to be opened from other computers...