Search results

Hi All, I have a major hair puller... I have a system whereby I have a Front End (FE) and back end (BE) for storing data etc. I am appending data from the BE to the FE into a local table to work on it (checking it "OUT" so no one else can work on it, then back "IN" when finished...) Problem...

Hi all! I have read up on Word Automation and Bookmarking to put data into a word template from a Db. Had a play, and it is going to work great! I am even going to give dynamically grab the bookmark name to put in a string. This is all good. However, my document, will have 100s of bookmarks...

Hi All, My Querie: I have a relational database, that is basically made up of a few tables, I will simplify for this to two. TblFieldNames and TblFieldValues Basically using a form you can fill in a field (TblFieldNames.FieldName) and it is then appended to TblFieldValues.FieldValue. On the...

Hi All, I am trying to update a fieldvalue with the result of a calculation and it is only updating it with the string, rather than the result (which works in other cases. Dim rst As New ADODB.Recordset Dim conn As ADODB.Connection Dim strcalc as String strCalc = (100+100) rst.fieldname =...

Hi. I have a recordset with 3 records (variable) each record has an Operator and a FieldID Dim strFieldValue As String Dim strOp As String The Operator is "*" but could be any other +, -, / The FieldID is used to pull a FieldValue using a function fGetFieldValue(strFieldID) as string.. I...

Hi all. I have a sub query that was working until a couple of days ago when it decided to stop. I have a Table called TblFieldValues which whenever a new value is entered into my relational Db. Each new Value is given a ValueID and is Dated (full date/time stamp) My Sub Query ensures that for...

After Searching the Web, I couldn't find anything that did something as simple as this, choose a color.... So here is one! Waste not, want not....please feel free to use it!

Hi. I have Form with 3 list boxes. 1st LB populates 2nd etc. The 3rd LB value chooses a field. The Fieldname Table has field "Field Type" I want to change the Text box next to the List box to this entry in the Db. Ie. If I choose a field in the LB, say "Done?", then to update that field it...

Hi, Firstly - Thanks in Advance! I have a problem with getting data out of Outlook. I have seen the ADO or DOA alternatives, but it is a little beyond me how to use them effectively, so I have found something that works for me, but.... I have got the info out of OUtlook into some strings...

Hi, Was wondering if anyone has converted from Act 7 to Access before? Is there an easy way? My Act fell over (bloody useless program) and I can't even get into the file a created; to have a play, and I have lost some data I would love not to have to DataEntry in again. Basically I have an...

Hi, I am positive this will be on this forum somewhere, so if someone can point me in the right direction, that would be great. I can't find the right keywords to deal with this on. I have a tblCompany, tblContacts and tblRelationships If I have an employee of Company X doing something for...

Hi, Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer. I have an Access Db that is not password protected, but is asking for a password. It opens on any other machine fine? I think my...

Hi all, I have an access Db that I use to manage contacts etc. I regularily send out newsletters and emails to the contacts in that Db. I want to know if there is a way I can essentially track the emails from access in outlook. eg. based on field "email" it can see the emails incoming and...

Hi all, I would like to thank you in advance for all your help, it has been great so far! I have an unbound form with a combo box [Forms]![Form1]![Combo1] The row source of the combo box initially was from a Distinct query that is from the original table. I then have a query with criteria...

Hi, I am trying, and getting nowhere...so would appreciate your help... to create a query where records with dates from 8 weeks, or two months ahead appear in the query. That is I have contracts ending in two months in my table and I want to run a query on who I should call now to renew...

Hi, I am having issues with a Sum Query. I have a number of fields with Yes/No and want the total for "yes" for the fields. When I do this with no criteria it works fine, but as soon as I add criteria based on other variables in the tbl it doesn't recognise certain records. The criteria I am...

I have 2 tables and I am trying to link them using a 3rd table, as per a previous discussion, this is a new enquiry. I have two fields on the new table that I want to display the same information as the first table. Ie. Co ID and Co Name. Is there a way to when selecting the Co Name auto fill...

I am designing a Db with several elements. I have 12 tables at the moment, all interconnected. Company Type A - select field 4 from table 2 Company Type B - select field 5 from table 3 etc The records in table one are related to records in up to 8 other tables. Ie Company type A uses company...

I am trying to make a query with one field, that has a list of one field from many tables. Can anyone help?