Search results for query: *

Hi, Trying to work out the difference between a given date and the start of the next financial year (April 1st) AXB Addition: DateDiff("d",[LHFH_Start_Date],"THE NEXT APRIL 1st") Can someone please help - thanks

Hi all having a problem with some users being unable to delete records in datasheet view I can right click a record and select delete record. However when some users right click on a record it will not stay highlighted. It "jumps" to the first record. This makes no sense to me as all users...

Hi, trying to refresh formA, on closing formB Placing a command button on formA (with wizard) I get the following code. DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 What I want to do is put this code under OnClose in formB. However I'm not familiar with DoMenuItem and...

My message box is a vbOkOnly style. All I want to is close a form when the user clicks on ok. I'm familar with message boxes in vb but I just can't seem to track down this answer! (usually use select case vbYes,vbNo etc) thanks in advance

Hi, I'm running a report with several subforms. Each of these subforms is based on a query that counts the instance of something. However when the query returns no data the subreport does not show. I been working with the subreports no data property: Private Sub Report_NoData(Cancel As...

Hi, I have a report that lists properties in Blocks. I have set up a group header that seperates each block. In the header is a list box that is supposed to show the number of properties in each block. Currently I have the below as the list box source: SELECT Count([1].Block_Code) AS...

hi - I have a subform (subform A) with a query as a datasource. One of the query fields is a "calculation": Days Late: IIf([Day1]<=14,"On Time",([Day1]-14)) & IIf([ContractStatus]="NOE PREPARATION","NOE") Users can jump into another form by double clicking on a unrelated field. However when...

Hi - trying to workout how to open a form if a criteria is matched. Using earlier strings I have come up with: Dim stDocName As String Dim strSQL As String Dim strSQLWhere As String Dim lngCount As Long Dim strHelp As String Dim crlf As String stDocName =...

hi - Having some problems seeting a default value and I think it's because there is more than one column (column widths set to 0cm,2cm) Trying to get it to default to the first record in a table. By amending previous threads I got to: DMin("tblTeamLeaders.lngEmpID","tblTeamLeaders.strEmpName")...

Hi, the below statment seems to works but could someone please check the syntax - thanks DoCmd.RunSQL "INSERT INTO tblContractsToProperties (GIS_Property_code, Property_Address, ContractCode) SELECT tblProperties.GIS_Property_Code, tblProperties.Property_Address, tblContracts.ContractCode FROM...

Hi, I have a form with two subforms on it, both subforms have different record sources. However subform A is used to update the table that subform B is based on. This is causing an error as subform B is locking the table. I've set the recordset type to snapshot and made sure that there are no...

Hi - I have a problem with a subform used to view notes added by users. The subform is in continuous forms view. (There is also another subform on the same page used to add notes - both use the same table). The notes added are often much longer than the text box can show, so I thought I would...

hi - I'm using the following code to fill a field when creating new records. Dim db As Database Dim tdf As TableDef Set db = CurrentDb Set tdf = db.TableDefs("tblContractsToProperties") tdf.Fields("ContractCode").DefaultValue = Forms!frmContractAmend.ContractCode However a contract code looks...

Hi there - I have a SQL statement wich is giving the error message: Syntax error (comma) in query expression '(GIS_Property_code, Property_Address)' Statement: DoCmd.RunSQL "INSERT INTO tblContractsToProperties (GIS_Property_code, Property_Address) SELECT (GIS_Property_Code, Property_Address)...

hi, I have a subform with a check box for users to pick individual records. The problem is that the underlying table is always 1 record behind: User clicks record1 checkbox in form; nothing happens in table User clicks record2 checkbox in form; table shows record1 checkbox = yes User clicks...

I need to create a form that links one record in tbl-contracts to several records in tbl-appartments. I was going to do this with a third table (table x) that lists contract codes against apparment codes. I have a subform that shows appartments with a checkbox next to each record. The idea...

hi - In a text box I have a currency amount of 46.324 The control source for this box is =([unit_total]*0.1) This logically rounds to £46.32 but I need £46.33, I've tried =roundup(([unit_total]*0.1),2) but I just get #Name (maybe because this is a worksheet function) can anyone help?

I have a query with three columns, Estate Code, Block code, Total Properties: Estate_Code Block_Code Total_Properties 10001 10 20 10001 20 17 10002 10 5 10002 20 6 What i want to do is add a fourth...

Having a problem exporting a report to excel, the report contains a number field. When exporting to excel the number field is given two decimal places (12345.00) Have spent ages trying to solve this, do not want to convert it to text field or insert a "'" into the field. Anyone know a...

I'm trying to get rid of a slight delay when opening a form with two subforms on it. I've tried all the advice in help and in other threads to no avail. I have noticed is that if I set the subforms Data Entry to Yes then the delay is removed. This is because Access no longer reads the...