Search results

Howzit Try turning the warnings off then back on again Something like docmd.setwarnings False ' your code here docmd.setwarnings True

Howzit Try intcount = DCount("*", "[tblopportunities]", "[NextChase] =#" & format([Forms]![FrmViewOpportunities]![NextChase],"mm/dd/yyyy") & "# and [CreatedBy] ='" & CurrentUser() & "'")

Howzit Put your dlookup in the afterupdate event procedure of your code selection. The dllokup syntax looks fine, you just need to assign it to another control me.yourotherfield = DLookup("PFO","tbl_Shipping_Charges","Item_ID = " & Me.ItemNum)

Howzit See this post http://www.access-programmers.co.uk/forums/showthread.php?t=222275

Howzit Try ... File >> Options >> Current Database >> Document Window Options = Overlapping Windows

Howzit 2. Tried this in a previous role and had continual problem with shared wrokbook always corrupting when multiple users accessing. Quite possibly our knowledge on getting this to work properly. 5. Consider SQL Server as a back end option. IF you are approaching a 2 GB limit in Access...

Howzit I don't see there being all that much to change really, even with 1200 records. Good luck with your project I'm sure you'll get there in the end. JOINS When you make a query based on multiple tables you need to join the two tables together. If you don't you get something called a...

Howzit By adding the Form_Current code (without changing anything else) to your initial database you uploaded requeries the combobox when cycling through your form records, but does not solve the text v number issue you have

Howzit Access does have subtle differences to T-SQL. Glad to hear it is working.

Howzit Changing the tables so it does not use lookups is straightforward. You just change in Table Design, on the lookup tab from combobox to text box. This will not change the design of the table or lose you any data, it just changes how you see the data at table level. No real re-arranging...

Howzit Try with bracketing sql = "update CBF_master as a " & _ "inner join " & tmpTbl & " as b " & _ "on (a.Year = b.dt_year) " & _ "and (a.Customer = b.Customer) " & _ "and (a.StockCode = b.StockCode) " & _ "Set a.Jan_FVol = b.Jan_FC, " & _...

Howzit This works for me. I have taken the liberty of removing the lookups so I could see the actual values in the tables. Please feel free to reinstate them if you wish - it is your db after all. I needed to change the cityfromcounty query to reflect the new bound column. I have changed...

Howzit Part of the problem is you are using lookups at the table level (which is commonly frowned upon). So what you see is not necessarily what is stored in the table. As you do all your data entry (assumption here) in forms there is no reason to have lookups at the table level - in my...

Howzit Sorry was paying attention.

Howzit Can you check that you see [Event Procedure] in teh Event tab of your form properties in teh On Current field

Howzit Did you add the code in the Form_Current section - this works for me. Changing the bound column to 2 will write the city name into the spotter table, but you need to form_current to refresh the combo boxes to view the "record" when cycling through records

Howzit Try SELECT Confronto.Data FROM [Confronto] LEFT JOIN (SELECT [2011].Prodotto, [2011].Data FROM 2011 WHERE ((([2011].Prodotto)=[insert product]))) AS T1 ON Confronto.Data = T1.Data WHERE (((Confronto.Data) Between [insert initial date] And [insert end date]) AND ((T1.Data) Is Null));

Howzit When you drag a field from your field list onto a form you will find that the Name of the control and the Control Source are the same value as the field name. However there is nothing to stop a user from renaming that control name. When you add a control from the tool box this will...

Howzit Set the Limit to List property to YES

Howzit It may very well be slight syntax differences between access SQL and SQL Try sql = "update CBF_master AS a " & _ "inner join " & tmpTbl AS b " & _ "on a.Year = b.dt_year " & _ "and a.Customer = b.Customer " & _ "and a.StockCode = b.StockCode " _...