Search results

Can I ask, why do you want to know this? Is it important to the result?

Hi, You probebly need something like a custom function to test it: Public Function ISUPPERCASE(strTestUpper As String) As Boolean Dim intTestUpper As Integer Dim i As Integer Dim test As Boolean Dim test1 As Boolean intTestUpper = Len(strTestUpper) test1 = True For i = 1 To intTestUpper...

All, This may a little difficult to explain but hopfully the attached DB will help. I am re-designing my database and I'm at an stop the process to change the data stucture. I originally had: Main Employee Table EmployeeID - PK/Autonumber GivenName - Text Surname - Text StartDate - Date...

Hello, I have a couple of questions: What happens if Perry leaves and Bob takes over his events/projects? Also rather than Perry being assigned in the Main Event/Project Tables you could Assign the events to Perry in a different table with Start Date End Date in that table, then you can...

Hi, Can you explain what you are trying to achieve with your question. That sounded rude, by that I mean. What I need is for me to run a report, which does x y z. With some specfic outputs you need, by what you have described it looks like adding only a few more line of data in the main...

Can I ask why you need 1 record to be moved??? Please expand on what you need

Hi, You could use a UNION Query to pull the information together, as long as the Field Headings are the same and he data is the same type, i.e. Number/Number etc. You will need to do this SQL view as the Query builder doesn't do UNION's, open a new Query and change from Design to SQL in the...

Hi, in the design view click the 'Σ' key and on the Field you want change 'Group By' to 'Max' Keep the same criteria as you have.

Hello, I think you're are missing the point of what I'm saying. I'm in a hurry currently but will post an example DB tomorrow. Can I ask First what the Registration Number, Company Name and Type are in your main table. I understand Reg, but Company (is this make of vehicle or something else?)...

A quick question. Why are you importing a new table each time??

Hello, Welcome to the board. Firstly, a point about how you are recording your information. You shouldn't be recording Registration Number, Company Name and Type in your WORK Database. You need to assign a Unique Reference in your Main Table. You can add a field (Call this VehicleID) and make...

As long as the name is the same then Access will do the job for you. You will need to create any relationships which you may have manually. If you created the relationship in the query you won't need to.

Hi, Firstly, I wouldn't put it in the Main Table with the names. Simply using the Query itself as the base for any other Queries and Forms is the way you should do it. What if Ian MacConnell changes his name????? IANMAC isn't valid any more. But, You can use: YourName...

BTW, works VERY fast. Thank you

HI, I'd better reply to SOME posts to earn this one back. I still haven't understood any of it, those auditors are really having fun!!! I do promise faithfully that I will understand ALL of it in time, no point otherwise. I have a query regarding my own data (see attached) The data I have...

All, Does anyone know how to Import a Dynamic Named Range from Excel. I have (well...ok...they have) workbooks, each one has a Named range 'MyTable'. Which is something like =OFFSET($A$2,0,0,COUNTA(A:A)-1,19) Access doesn't see this type of Named Range. I wish to loop through each...

Blimey :D I took your DB work to...well...work. I must say I haven't had time to really digest what is going on, we have the auditors in on Monday so it's been battle stations. I do have a question though, I can't see how I'm eventually going to utilise this in the way I hoped. This in it's...

Hello, Not sure how you can have the FE in the same directory as the BE, the point of the FE is that it is Client side. Also, how do they log in for outside of the office?? One thing which may work for you is to locate the Directory through the Network, NOT I:\Path\Database.mdb BUT...

Blimey, I taking this to work NOW! Looks exciting, I'll post back tomorrow. Good work fella.

Hello, I finally have the rules, or should I say had the time to post them. They're actually pretty simple. With regard to current year Annual Leave, as mentioned, all calculations are based on 365 days. Previous service is calculated as days (StartDate - EndDate + 1) and then divided by...