Search results for query: *

Hi Lads, Hope all's going well today. Ive had this real annoying problem for the last while and have been avoiding it. I have a database which can prepare a six monthly report for our consulate here. It works quite well and basically lists all applicants, fees payed and exchange rate. The list...

Hi everyone, Ive just used dLookUp() for the first time today, and thought I had got the hang of it but evidently there is something wrong. Here's whats happening, if you can help at all please let me know I have a report, which will display record information including name, fee and...

Hi people I have an add record form where the user adds the date that an application was filled out. I need to know how I can check on start up whether the date entered is the 1st of the month. I know there is a month function but how do I check if its the 1st? thanks for any help I love you

Hey lads I have a nice report for our bi-annual consulate report which shows how much each applicant paid and in what currency. There is also a field for each record for the converted fee. However I want to prompt the user to input an exchange rate for each page or even for each group of 30...

Hi Guys Could anyone help me with the syntax for this expression Im using on a report. The textbox field is supposed to display yes or no depending on the text in another field. So on my report I have the fields listed like name, job, fee, currency simply listed from a table. The last textbox...

Hi People Im having this continuous problem with subform referencing. Let me describe the form fist of all. I have a main form, which is used as a navigaiton window to switch between various forms by just clicking one of the command buttons across the top. (frmMain) So the user selects...

Hi Everyone, I am trying to create a report from the search results displayed in a subform. I have tried to use the openArgs function but it just displayed all records, not the searched ones. So now Im trying a different approach but am having the same amount of success, none. Here is the...

What I want to do is to create a report based on the results displayed in a subform following a search. I found this link from Microsoft about how to print a report based on a recordset. http://support.microsoft.com/default.aspx?scid=kb;en-us;132881 The problem is, is that you need to enter...

Hi Guys Im getting unusual errors when tryint to search for records between two reference numbers. Here is the code for search Private Sub cmdShowRefRecs_Click() Dim strSQL1 As String, strOrder1 As String, strWhere1 As String strSQL1 = "SELECT qrySearchVisaSub.Ref_No, qrySearchVisaSub.Name...

Hi everyone, I have been searching various sites to try and solve this problem but as of yet I cant find a solution. when I change the syntax I get a different error each time Im trying to compare a string entered to a text box(via a popup calendar) and those in a table. But I get a syntax...

Hi people I have a mainform and below that a subform used to display recordsets. On the main form I have a "refresh list" button, which justs refreshes the data. I have been using the following code but I get a STRANGE error when I click the button "runtime error 2465, M.Access cant find the...

Hi Guys I am a newbie to Access and have bitten off more than I can chew with a project Im doing. I am in dire need of your expertise and would be eternally grateful (really) for any advice you can give. I have a main form (frmVisaSearchMain), which contains various textboxes and combo boxes...