Search results

Good morning all, Need some assistance for the attached file.... I need to count the "X"s in Villa Occupancy sheet based on villa number and date ranges, for example, for January 1 to 31, villas 101 to 122, total of "X"s.... Both criteria sets are in the Summary sheet for linking. Been trying...

Good Morning Guys, Bit stuck with a small dilemma and hope one of you guys can help me..... Trying to list some countries based on the data in column O, when the data is not same works god, but when I have same, it only picks up the first entry from the list Basically I have an index/match...

Hi Guys, I'm trying to use 'me.allowedits = false' statement in one of my forms but it doesn't make diddly doo difference, I put it in the load section of the form, is there a magic trick to make it work? Or, is there any other easy way to make the form read only, there are plenty of...

Good afternoon guys/gals, I'm trying to assign a value to a text box on form load with below code but Access tells me I can't.... As usual, what am I doing wrong? Also tried .value, same error..... Me.Text981 = DLookup("[CompanyName]", "tblVendors", "[ID]=" & Me.VendorName)

Hi Guys, Trying to add a record to an existing table from the form data, which is already linked to another table and of course, failing spectacularly !!! Below is my simple code and I am getting a syntax error in the HotelName field to start with, probably next ones will also follow ;) Where...

HI all, in order to hide the gray Access workplace, I created a form, maximise it with a picture but after this none of my form buttons for close/open reports etc are working Background image form is simple, no buttons etc, not modal/pop-up and other forms open on top of it Any idea what am I...

Hi Chaps, Me again...... I have resolved few steps in my Crosstab query issue, now can filter for 2 fields ! But I need more.... As usual.... I have attached my sample DB, and this is what I need to do but have no idea how to Table tblSalaryScale contains salary details by...

Hi guys, After spending days searching for a solution for the OutputTo save a PDF file on a network drive failing miserably, I give up..... Now, I need to find a solution, ie a VBA code which does the same, to create a PDF, name it as per the code and save it on a network folder provided in...

Good morning chaps, Small Issue came up....... Private Sub PrintInvoice() Dim strfullpath As String Dim varfolder As String varfolder = "S:\NATIONAL HOTELS\99 Project Database\Files\InvoiceApprovals" strfullpath = varfolder & "\" & Me.VendorName & " " & Me.InvNo & ".pdf"...

Following from my other thread, I managed to create the crosstab query Pat was suggesting, DB attached Now, issue is the column headings and filtering I have inserted the criteria based on the form variables, and fixed the column headings (only way I managed to make it work.. as propertyIDs) -...

Hi Gurus, Me again, trouble maker .... Yet another Dlookup related problem... This is what I am trying to achieve...A table with propertyID/Year/Department/Position/Salary details to compare 3 property's salary details by department and Position. Created the form, in header you select the...

Hi guys, Me again, Trying to Dlookup a numeric value with 2 text criteria Me.BillingRate = DLookup("Rate", "tblBillingRates", "Category = '" & Me.Category & "'" And "Position = '" & Me.Position & "'") With above I get type Mismatch Error 13 and for love or god, can't understand why...

Good morning site gurus ! Quick questions, working on a contact database and would like to include a pic of the business card in the contact form. 1. How would I display the picture in the field when form loads? 2. How can I limit the size of the file loaded so no pics about 100mb are loaded ...

Hi guys, I have this code for password change on a form, but cannot get it to work, keeps asking value for intUserID on execution, where as I already have assigned in green highlight , cboEmployee is a unbound filed on the form WHere am I going wrong? Private Sub Command147_Click() Dim...

Good morning/afternoon/evening guys, I want to place a field (unbound) on my form (Unbound), which will display a record from another table which contains one record with an attachment, to serve the said file as template so user can open, use and save somewhere else How can I link this unbound...

Hi Guys, Trying to sum fields based on a ID from a form, and a text field, fixed - my version is below - what am I doing wrong? =DSum([total],[qrybudget],"[ProjectName] = " & [me].[ID] & " And ctrBudgetType = 'Seed'") ProjectName is a number field, and ctrBudgetType is a text..... Thanks in...

Hi Guys, Its me again....... I have written below SQL to list all contracts with invoices to run a report, but unfortunately, it only results contracts with invoices attached to it, but I need the zero ones listed too How do I achieve this? SELECT tblProjectContracts.ProjectName...

Hi Guys, I'm getting desperate...Whatever I do, doesn't work... Can someone pls convert below to a DSUM function for me? SELECT tblAreas.ID, tblAreas.Project, tblAreas.Cost From tblAreas WHERE (((tblAreas.ID)=[Forms]![frmProjectContractEntry]![AreaName]) AND...

Good morning all, Novice user here, trying to join 3 tables, namely tblContracts, tblProjects and tblInvoices.... Idea is to have a query to run a report - see Financial Report by Area, where it shows projects, associated contracts and associated invoices received , managed to join projects...