Search results

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...

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...

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...

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...

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...

I have a problem which seems fairly simple, though the execution is beyond me. I need to monitor the activity of my clients, based on records in two tables; tblCases and tblNotes. I only need to know how many "hits" each customer gets per month. A new case would be a hit, as would be a note (a...

Hi there, Elsewhere on this forum there is an example of how to add a calendar item to Outlook via Access. There is also an example of how to pull out a single appointment, edit it or delete it. I'm storing a unique ID in the [mileage] field in the appointment - and if necessary, I can store...

I've been using Access 2010 for a little while - and it's been pretty positive. The other day I split my db and I appear to have a problem now. Since doing the split, I cannot open the DB, even if I hold down <shift> if I'm not joined to the Network the data backend is located on. (It just...

Hello, I have a continuous subform which displays only one field; though there can be quite a few records. Currently, you can view all of the records using the vertical scroll bar; but to be honest, I don't think this looks terribly good - I'd rather display 5 at a time and create navigation...

Hi there, Is there a way to check for an existing record (by dlookup, or otherwise) before inserting a new record? I have a table [tblActCouseElements] with two fields; one numeric, called courseID and one text, called element My form allows someone to select from a list of options, which in...

I don't normally get too many challenges with tables, but I'm struggling here, and as far as I figure it, it should be possible without forms or vba. On the (attached) DB, I have a series of tables for tracking training courses. - The main table is [tblCourses] - Every course has a "Course...

Hi everyone, Can anyone explain what is happening on the form attached? When you cycle through the records, the text face "deepens". it's certainly not intentional or desired. Any clues? :confused:

Hello, I have three tables; tblCourses ,tblCourseElements and tblElementnames tblCourses contains details such as dates, locations. tblCourseElements contains the descriptiveID of activities within a course and associates them with a courseID tblElementnames simply stores the string describing...

Hello folks, Is there some natty way to display, in a continuous form or otherwise, so that you can have more than one column for the same field of data... I.e Say we are displaying the data from one field from one table, and it has 30 entires, yet my form can "fit" 10 from top to bottom. Is...

Hello folks, I have a an unbound popup form (popNewCustomer) that allows the input of data into a Customer Table (tblCustomers). Once the form has been completed, I have a sub that puts the completed forms data into the table via an SQL Insert. All good. The form then closes. I'd like to...

Hi folks, I'm struggling with the exact syntax to do the following. I have a subform(sfrmContacts) on a form(frmMainDisplay) I'm using the subform as a placeholder which switches between two subforms that essential display a list of contacts(sfrmContacts) and a detail of a selected contact...

I have a small application in VB Ex 2008. I'd like to store all of it's variables in a text file. I'd like the application to read the file when it launches to complete the variables in the app. I would also like to put some code behind a button so that if any of the variables are altered in the...

Now, is there any way to change the default unit of measurement used by Access to pixels given that VBA wants to speak in pixels as it's unit of measurement? I see the controls are affected by Regional settings, but with a choice of inches or centimeters, neither gives the convenience of...