Search results

I have a database for tracking, among other things, student debt for units completed. Four times a year, we produce a letter for each student, detailing the unit of study completed that quarter, how much they owe, and various other info for that quarter. We use Albert Kallal's mail merge...

I have an Access 2007 db and I have just migrated the backend to SQL 2008. My multiselect listbox has stopped working. Does anyone know of an alternative method to store multiple values? It's an enquiry database and the listbox is used to tick courses of interest for prospective students.

I have a form with a number of subforms but instead of using tabs, I inserted an unbound subform where the sourceobject changes depending on the command button clicked. The data displays correctly, however, every time I go to add a new record, I get the error: "You tried to assign the null...

Is it possible to create section headers within a combo box? I have a few fields linked to value lists but I would like to segment the contents to make them more readable. I don't want to use cascading combos if i can help it.

I have a small app for school use and was wondering if anyone knows of a way (or even better, can point me to a sample) that I can create a form that includes a few controls necessary to design an id card. Basically, I want my users to be able to go into the form and add fields from a table...

Any IIF wiz out there? Fields are as follows: AmountPaid AmountCharged Status If [Status] = 201 or 202 and [AmountPaid] >=$500 or <$500 but >= 80% of [AmountCharged], then result is [AmountPaid] x 1.25, else result is [AmountPaid] Challenging for me at least, I'm sure someone out there...

Hi All, Need to restrict a control as follows: Max number of chars = 5 Allowed chars = any combination of "QSTURV" or the letter Z on its own Strange one I know but it's for a third party system. Cheers, Andy

Hi Guys, I'm setting up a form that requires quite a lot of information. Here's the rundown: Student Information Tab 1 (Contact Info) = 27 fields (9 of which are combo) Tab 2 (Personal Details) = 20 fileds (10 combo), 1 option group, 7 option buttons Tab 3 (Enrolment Records) = courses...

I have a date field [CourseDate] that I need to return as: yyyy01 if the record falls between 1st Jan and 30 June of any year or yyyy02 if the record falls between 1st Jul and 31 Dec of any year Eg. If a course was on 03/02/2009, result would be 200901 etc.

I have an existing procedure using transfertext that utilises an input box to prompt for the filename to save to. I would really love to customise the input box to fit in with the overall look of the rest of the application. Can anyone point me in the direction of some instructions to do...

Hi all, I hope someone can help. I have an access report with an unbound OLE word document linked inside it. The report is basically a letter in response to a customer enquiry. I've used data fields for the name, address etc. This works great and allows users to change the letter to...

Hi All, I'm sure many of you already know how this is done, but for any newbies like me who've spent ages searching this forum and loads of threads on other sites stating that it is not possible to disable the office button, this is for you. Apologies if this has already been mentioned in...

Can anyone tell me what I'm doing wrong with this statement: Location: (IIf([ResidentialAddressCountry]=("") Or IsNull([ResidentialAddressCountry]),"A" & [HomePOCode],"X" & [ResidentialAddressCountry])) It works if ResidentialAddressCountry is empty, but the else section doesn't work - just...

Hi Guys, Just a quick one. I use the following code to export my query to file but I've found a bit of a bug in my code. When the user clicks cancel on the input box, my next messagebox still comes up and then errors out. Could somebody please advise on how to deal with this by...

Hey guys, Any help would be greatly appreciated. I'm using a transfer text macro to create a text file for upload into a 3rd party system. Problem is, the 3rd party system has pretty strange naming requirements and I need to create the file without the txt extension. Does anyone know...

I have a combo box on my form called "Location" that I would like to link to two tables. Table 1 is a local suburb/towns list Table 2 is a countries list I would then like to tick a box to determine whether the location is local or overseas, and have the combo box give me the correct table...

Hi all, Hope this isn't too silly a question. I have a currency field in my database that needs to be formatted in a specific manner for output to a 3rd party system. The number needs to include 8 digits with trailing or leading zeroes. Eg. $585.00 = 00058500 $585.45 = 00058545 If...

Hi all. Please excuse my ignorance, I'm a bit new at this. I'm setting up a fairly simple customer database for a fashion wholesaler. We have a set of customers who will be in tblClients, and a set of brands in tblBrands. I would like to have the ability in a form to view all the contact...