Search results

I've got a very simple if statement set up around a recordset / query displayer. It is meant to check if a certain cbobox is blank. If so, then error and exit the sub, else compile the query and execute. For some reason though, it's acting as if the if statement doesn't exist and runs the query...

Hi all, I've built a small(ish) function that I referred to in another thread, here. It currently uses Dlookup, which is simple but far too slow. I'm trying to convert it to use Recordsets and being completely new to their use, I've come up with the below. Function get_invoiced_test(hosted...

Hi everyone, I'm writing a small function that will be used to calculate some revenue numbers based on a few conditions. One of the conditions is a delay period, in weeks. It's stored in a table, but let's say it will be 4. I want my function to take a number from the current record, Number...

Hi all, Stangest problem happened today, I went to open up our database, which automatically opens a UI form. Holding shift to bypass this normally shows the objects window, but today it was gone. All that was left was a neverending scrollbar at the bottom. I've looked around for a solution...

Hi all, I have a small problem here that I don't know how to tackle. Imagine your generic monthly revenue report in excel. You have the days of the month as columns and the values like gross revenue, net revenue, profit etc as rows. I want to replicate this in Access using a table field week...

Hey all, I'm trying to change the forecolor of control A on a subform based on the value of another control B on the same subform. The subform displays as a datasheet. Here's what I've got in control A's conditional formatting box: [Control B]>=(Format([Date],"ww",0,0)) Control B...

Hi all, been a while since I asked for help but it's that time again! I working on an append query. The query is creating a record in tblRecords for each combination of Partner, Week and Genre. So if we had Partners A, B and C who use Genres 1 and 2 and we have 52 weeks, that would result in...

Hey all, I'm trying to make a simple procedure that will check if any items in a given listbox have been selected and if so, continue, otherwise give an error. Here's what I've got: For i = 0 To lstChannel.ListCount - 1 If lstChannel.Selected(i) Then Exit For Else MsgBox...

Hi all, In our database, we are tracking revenue figures. The required metrics, found in tblRecords, are [Revenue], [Gross revenue] and [Net revenue]. The only field that needs to be entered manually should be [Revenue]. The other two are then calculated from [Revenue] by multiplying by [Share...

Hi all, I've worked out one of my other problems almost to completion - I've created the following code which creates records of all combinations of listboxes chosen on a form: Private Sub cmdSave_Click() 'DoCmd.SetWarnings (0) Dim Sql As String Dim PName As String Dim Channel As Integer...

Hi again everyone, thanks for the help so far but I need more! I have a form (image attached for reference) that is used to create a new set of records. Users select the partner, the countries where it is present from the listbox, checks the channel boxes as applicable, fills in the remaining...

Hi guys, At the moment I've got a form with a subform. On the form are 5 comboboxes that filter the subform. I want to be able to export the filtered recordset to Excel and through my reading it seems that a query is the best way to do it. I'm having problems getting the variables from the...

Hey guys, My database is coming along nicely and I want to cover a few things that I havn't been able to yet. I have a partners table and accompanying form. One of the fields here, called default % share asks for a percentage (for a revenue split). This is used in 90% of cases, but the other...

Hi everyone, this is my first post as I've just started to work with Access after a LONG break. I remember the very basics but I'm stuck on what I think should be a simple problem. In the attached image you can see my table structure. Basically, I want to have one main table (Data) where our...