Search results

Hi there, I was wondering if I could get some advice please on testing code that will only change yearly. I have created a LogNumber (CustID), With a customisation of the code that I have found in this forum thank you...

Hi there, Hope all is well. I am building a database at work. I was going to use the multiple field in access but then that didn't fit the design principals and also reading some other posts apparently it isn't a good idea to use this functio anyhow. Maybe I am not doing this correctly. So...

Hi There, I hope I have put this in the right place. I had tried doing this from another post on here suggested txtUniqueNumber = Number & Format(Date, "ddmmyy") & ID What I did was txtUniqueNumber = Format(Date, "yyyy")&"-"&ID Didn't quite do what I wanted. What I am trying to achieve...

Hi there, I have been trying to figure out how to make a textbox if it is null to be invisible on a report. My experience in programming is somewhat limited so any help is greatly appreciated. This is one of the ways I have tried but I maybe on the wrong track. I selected the detail section on...

Hi, I was wondering if anybody can assist me with this. I have a report I have created for Income as per the attached .xls. At the moment it is showing values for the whole year. What I will be doing is creating a parameter form similar to the one attached(.xls file) to select the dates as...

Hi, I have created this report for monthly expenditure the only problem is once the report is run it only fills nearly half a page what I would lilke to happen if possible is the format to fill the one page. It will never go over the one page. But it will have to adjust according to how much...

Hi, I have created this list report, but I have now being trying to format it so that the report header will be in the centre of the page and also the page footer. As well as the headings of the values repeating on the other half of the page also. Name Phone Handicap 2/3H/C I have...

Hi, I have an issue with a crosstab query. I have two tables Tbl_Main with a one to many relationship with Tbl_Expenditure as per the attached excel spreadsheet. I need to add two records with the same date as the cheques were both written on that day. But I need to record them on different...

Re: Cross Tab Query and Totals Hi, What I did first was to create a cross tab query as below, TRANSFORM Sum(Tbl_Expenditure.Amount) AS SumOfAmount SELECT Tbl_Main.Date FROM Tbl_Main INNER JOIN Tbl_Expenditure ON Tbl_Main.MainID = Tbl_Expenditure.MainID GROUP BY Tbl_Main.MainID...

I am creating a report in Access 2010. What I want to achieve is that the information that is printed is to stay on one page so I would like to make two columns. Is this possible? I used this query first but it didn't seem to work. FullName:[LastName]&"...

I have a little bit of experience with Access and have completed a Database Design and Development Course at TAFE giving me the theoretical side of databases. But I still have a lot to learn on the practical and theoretical side of databases. My hobbies are car racing, hiking, arts and crafts...