Search results

Well, I have this half sussed. I figured I needed an array and For, Next Loop. This code does pretty much what I need it to do: 'The final step requires us to install the notes into each ProjectTimeline we just made. 'We already know the Project we just created, as it is stored ar newProj 'We...

Hello Friends, As part of my DB project, I often use Insert Into VBA to automate append queries for my users. This works really well, but I have a situation which is a bit complex for me to get my head around. My DB contains a module with three tables: tblProjects tblProjectTimelines...

I have indeed re done the entire form, it was useful to know where the issue was though. Yes, each user is deployed their own copy of the front end when they log into a PC, they must be signed into Sharepoint and this in turn lets them connect to the lists stored in the back end. It's worked...

You are not wrong, the corruption appears to be in the field which adds up the number of Items (=sum([lineqty]) , removing it and replacing it fixes the summing up. :banghead: Thanks all for steering me to the solution.

Cheers, I'll have a look at that later and try a rebuild. That DB is a segment of a much larger DB where the tables are sharepoint lists. I've ripped out only the relevant tables and forms to the problem (and converted the tables to local ones). The extra fields in the tables are put there by...

SalesQuantity

In sfrmSaleLines, next to the label "Cost:" this Text box houses the field "linecost", but the text box control is called SaleCost. Same with "lineqty" - click on it and you'll see it is called something else. Although the other, working form, field and text box control have the same name...

:( Still no joy.

No, I had read Access can confused fields and text boxes, so [LineCost] = "SaleCost". and [LineQTY] = "SalesQuantity".

Thanks for the reply. I had considered and tried that - it again returns #error. The big puzzle is why on one form I have a working version and on the other, with few changes, it consisently returns #error.

Hello everyone, it's been a while! I'm adding to a DB which has been working well for a while, but I'm stumped on something which seems a bit silly. I have a continuous form which has a query behind it. The query takes two values: (For example) [LineCost] and [LineQTY] Inside the query, we...

Hello, I'm fairly new to Macros, and where I'd never struggle with this in VBA, simple things with Macros are foxing me. I have a Web-Table with a Date Field [CaseDate] I have two search boxes, [DateFrom] and [DateTo] - I need to filter the table based on the dates in the search boxes and...

Sorry guys! I don't feel good about bumping; but does anyone have any clues here? Thanks

Hello everyone! We've been using a database quite successfully for some time to log customer queries. I used some code from http://www.tek-tips.com/viewthread.cfm?qid=1346884 that allows my colleagues to copy and paste an email from Outlook 2010 into the Access DB field. The code copies the...

Re: Manage Users and permissions Acces 2010 Seconding Jonathanchye. I've used his code (thanks, Johnathan); it's simple to understand and works a treat.

Sorted. I've changed the code to only format the date in the SQL section. It works fine now. Thanks

I have using the following code to insert records into a table. This is for contract work where, for example, an annual contract might be paid monthly. The vba takes the start date, and the total amount and cuts it up, accordingly - depending on the contracts length (be it 12 months, 24 months...

I have a simple form / subform arrangement. The subform is a continuous form based on the selection in the parent form. Sometimes it might have 1 item in the subform, sometimes many. Once you get over 4, you need the scrollbar. No problem, the Scrollbar property for the form does the job...

Whenever I do this, I usually lock down / unlock the fields with the following code: Dim ctl as control For Each ctl In Me.Form If ctl.Tag = "LockMeDown" Then 'In the controls' properties, set the tag ctl.Locked = True 'Can't be edited...

Hello Folks, I've long lurked around these forums, asking questions and once of twice putting a bit of input in, where I can. I work for the IT department in a telecoms firm in north east Scotland; pretty general stuff, though a few of my customers rely on us to support their access databases...