Hi Kadghar,
Thank you very much for your response! It was spot on. After I added the code above at Line 17 it worked.
The dilemma has evolved a little.
I've added in a functionality to also convert 3 and 4 digit time codes to be converted into the desired time format (i.e 112 becomes 01:12 [am], 1545 becomes 15:45 [pm]). These time codes are in a separate set of columns. Similar to my original issue whilst...
James Grant
Last Activity: Oct 24 '11, 05:04 AM
Joined: May 15 '11
Location: Brisbane, QLD, Australia
-
Excel 2003 - Date input mask with VBA 6
Hi Everyone,
Like many others before me I have the often asked question of how to create an 'Access-like' input mask for hastening date data entry.
Using C Pearson's much quoted code I've modified it as such:
...Code:Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim DateStr As String On Error GoTo EndMacro If Application.Intersect(Target, Range("C2:C1000")) -
Again NeoPa your breadth of experience shines through. The WhereCOndition parameter should do the job well. I will start tinkering and experimenting.
Many thanks for pointing me in the right direction!Leave a comment:
-
Set report format, different SQL query underlying the data
Hi Everyone,
I've read the Insight article regarding this topic (Courtesy of MMcCarthy); however I suspect there might be an easier way than the mentioned extensive VBA coding.
My situation has spanned several posts now (first post), and I am still as of yet to post my promised summary code / database structure (sorry! Undergoing a revamp currently), and I now find myself in the situation of writing multiple, repetitive... -
Hi NeoPa, thanks for your rapid reply!
I'm sure you've heard this many times over, but within 10 minutes of posting this topic I thought to myself "Oh you've got to be kidding...THAT' S IT!" Glaringly obvious haha.
After updating the syntax as you also concluded the query worked perfectly and I'm on to my next query/report.
For clarity here is a copy of the functional, corrected code:
...Leave a comment:
-
SQL query to find covering staff - Syntax error
Hi Everyone,
To my understanding this code should work; however there's a syntax error somewhere within the sub-query and I cannot find it. It's very possible that my understanding is insufficient and there's a better way to achieve my ends, hence a little background on the motivation behind the query:
I run a staffing database for my department. My boss wants a report that can be run to identify which staff members... -
Hi All,
Just a very quick update on my progress to date:
-After restructuring and relating my tables as per earlier advice I was successful in creating a 'combining query' that allowed me to view the data in the Allocations table plus clarifying information such as the Staff ID's relevant Name (from Staff table) and the Position codes relevant Title and Description (from Positions table). This combined query, I presume due to...Leave a comment:
-
Hi All,
Firstly, SmileyCoder thank-you for your explanation. I'm still processing through it at this moment but I know it's saved me a lot of heartache searching through forums and help files.
Secondly, a further query for all (and I feel that it adheres to the original thread, please correct me if I'm wrong) regarding forms, subforms and sub-subforms as a possible solution for viewing all this interlinked data.
...Leave a comment:
-
Hi TheSmileyCoder, NeoPa and Mary,
Thank-you all very much for your replies!
SmileyCoder, your example database was fantastic in highlighting key ideas and programming for me. I'm finding it very useful. I have a couple of questions though if you don't mind:- The Staff ID text box (bound to KEY_Person) is 'Disabled': I'm not familiar with Enabled/Disabled text boxes. I would have assumed disabling the text box would
Leave a comment:
-
Hi NeoPa,
I'm glad I could be somewhat of a surprise for you. It all seemed fairly common sense to me keeping each topic about that topic, but I work in healthcare and I appreciate how uncommon sense can be at times.
Thank-you for your reply, I have started a new thread and hope to learn much from you and the Community.
-JamesLeave a comment:
-
Query combining results from multiple tables, data cannot be modified
Hi Everyone,
This thread originated from another topic previously posted.
Whilst designing a database I have encountered a significant issue in being able to generate queries that combine data from multiple related tables (e.g. generating a query that combined information from the Staff, Positions and Allocations tables to allow me to view a Staff name, Allocated position number, and Position description [using the common... -
Hi NeoPa,
Thank-you very much for your rapid and comprehensive answer.
I intend on re-designing the database in light of the article on normalisation you referred to. I fell into a trap of believing there was such a thing as too many tables, when further normalisation would have probably saved me a lot of trouble initially.
I have tested the syntax correction you posted which worked 'perfectly' in my flawed...Leave a comment:
-
Update query with Dlookup function results in conversion error
Hi Everyone,
I've created a database (MS Access 2003) to help monitor staffing at my work.
I now need to transcribe data from one table (tblPositions) into another (tblTeams) based on a common column (Position ID). Essentially I wish to copy the [Position title] and [Position description] of different positions from tblPositions, into tblTeams according to their already recorded [Position ID] (this is to make the data more...
No activity results to display
Leave a comment: