Search results

Sorry, forgot to put - this isn't working!!! PLease can someone see where I've gone wrong.

Hi, Could you please look at my code below. In a nutshell, I'm looking to cross reference a secondary "Continaution" reference with the original "Blanket Agreement" reference. To Do this, I have a Dlookup to lookup the "Continuation ref" in Tbl_Cont (That has 2 fields - Continaution ref and...

I made it work with the following: "[Blanket Agreement Number1]=" & "'" & [Blanket Agreement Number] & "'"

I've tried delimiters, but I just get the "Enter Parameter Value" for Blanket Agreement Number

I have multiple forms that I want to open this way to make sure that when I open Frm_RPS001 it will show the same blanket agreement number as the blanket agreement number that is currently open on the frm_Shikomiregister. I based this on the previous code that I used on a previous version...

Hi Guys, Can someone check the below? This is not working for me. Blanket Agreement Number1 is a text field Blanket Agreement number is a calculated field. DoCmd.OpenForm "Frm_RPS001", acNormal, "", "[Blanket Agreement Number1]=" & [Blanket Agreement Number], , acNormal

Thanks Paul, Just what I needed

I have a crosstab query that splits and lists an amount of data by month. The problem is, I dont always have a full year, so when I run the append query, it tells me I can't as some of the headers (months) are missing. Is there a way to skip this error and just upload a 0 if the month header...

Hi Guys, I'm using the below code to import some data. Its kind of the "quick entry" version of a form when my colleagues have to fill out 10-20 odd forms one after the other. The only problem is, its importing 1600 extra lines and creating 1600 blank records. How can i stop this...

Thanks CJ. I'll have a play around. Never really used a cross tab before.

Hi Guys. I need some help. I have some data that is month dependant. It is going to be uploaded to Access 1 month at a time, with the month noted in the "Month" column. I then need to split it into the 12 months. I have attached a picture of a screenshot of the way that I am attempting it...

I've managed to fix it buy using the below in the field Fy_YR: [Please Enter Year]+1

Hi, I can get the expression to work, but I can't seem to get the [?] to work. As soon as I start adding this in, the query stops returning records. I've tried putting the [?] both o the expression line and then also on a seperate line under FY_year. Please can you explain where I'm going...

Hi, I have a query whereby I have a [?] in the Year field so that the user selects the year. The query then selects the data dependant on the month. The data needs to conform to the financial year, so January to March would be year +1. However, when i set my criteria as [?]+1 (just guessing...

Thanks, this has solved that issue, but led to another. If there is a record in Tbl_reports with a blanket agreement number, this is now opening that record and overwriting it with the new blanket agreement number. Can I add in a line beforehand that says IF isnull (ME.Openargs) then add a new...

Both forms should be open. To open the Frm_Reports you have to click on a button on Frm_ShikomiRegister. The value is stored on tbl_ShikomiRegister. I was using it from the form as I want Frm_reports to open with the same value that is currently being seen Frm_shikomiregister. I dont want to...

Hi Guys, I'm looking to autocomplete a field on opening of a form. I want Blanket agreement number1 on Frms_Report to automatically be entered with the Blanket Agreement Number from Frm_Shikomi Register. I'm using the below, but it isn't working. Can you advise? Private Sub...

Hi Ranman, Your method wasn't working for me, and I didn't want to give another text box to open, so I have used the below DoCmd.OpenForm "Frm_Reports", acNormal, "", "[Blanket Agreement Number1]=" & [Blanket Agreement Number], , acNormal On Error Resume Next DoCmd.OpenForm...

Hi Guys, I have two tables that are related by a field [Blanket Agreement Number]. What I'm looking for, if possible, is as follows. I have Form 1 for Table 1 which is a "Register." Information about [Blanket Agreement Number] is held here. I want to then open Form 2 for table 2 where...

Thanks guys!!