Search results

Hello, Please help I have a List Box set Simple (I mean multi select). A Button nearby opens a Report which returns the List Box selected records – that works fine. Next, I want an Option Group to perform a filter on Field1 of the selected Records. What’s the best way to approach it...

Northwind is very good if your business is called Northwind. But. Adapting Northwind to suit your business means that every time you have a problem you won't know how to fix it. Dump Northwind - write your own DB - then be inspired by Northwind

generally speaking, If you're being paid by a customer or an employer - your work is owned by the customer when you're fired. Software isn't copyrightable anyway. If you design a better Word Program - microsoft can't sue. That's becasue software is like a recipe of different stuff. In...

Hi Sohailcdc I am new on here too, so my answers are a bit flakey, Period 1, Period 2, Period 3, - are they seperate fields? or three entrys (1,2,3) in a Period Field? Is the maximum Periods 12? or an infinate number? You might want to seach on DB Normalisation. And 1 to Many...

Combo Boxes don't belong in Tables - even though Access lets you do it! And tells you that you can too!! I didn't beleive the good people on this forum when they told me that! - I am a bit wiser now.

Thanks again Boblarson - I need to learn a whole lot about "variables" and "declaring variables" I will change my code to your suggestion - it's way cleaner than what I've come up with. I tried an "Exit Sub" in my "If Statement" and got something which looks okay... Private Sub...

Thanks Boblarson. Can I have the TimerInterval Event do one thing on one pass and another (different) thing on a second/third pass? I tried an "If else Statement" - but the Form_Timer Event does all parts of the "If else Statement" at each Interval. The next thing I am hoping to achieve...

On a Form, how can I set a time interval between two lines of code? To explain, here is my solution (of course, it doesn't work) Form1 has 2 Labels (arranged to look like a traffic light) their Properties are; LightRedLbl.Visible = False LightGreenLbl.Visible = True The Form Timer...

Oh dear. When creating my Date/Time Fields in the Table, I made the Format General Date. Was that wrong? If yes, should I have used a Form, Text Box, Format General Date, to add the data to a Table? I'll try your DateValue() Function Pat - Thank you very much. Thank you too to jdraw...

Field1 is General Date Format - I'd like to query using the Date() Function But that doesn't work. I tried creating Field2 in a Short Date Format with a Short Date Input Mask and used VBA Field2 = Field1 Planning to use the Date() Function to query Field2 and sort Field1 But that...

Plog has it right. your problem has nothing to do with macros - and you can manage without macros anyways (apart from maybe autoexec) - it can all be done in VBA.

Has a Spaced Repetition Algorithm been written for Access? As you know, Flash Cards are great for learning Languages, medical stuff, anything at all really. I'm learning all of London to be a Black Cab Driver. It'd be great if Access would show a Forms (flashcard) and calculate from the...

Plog is right. I didn't see his answer before posting. I was sort of imagining your boss needed an answer (the right answer may be above your pay grade LOL) Getting the left two characters from a field e.g. 7Y from 7YHA is a Left Instring function. In a query column (design view) have a...

Users shouldn't have to enter the same data twice - indeed the same data shouldn't exist twice. Nevertheless, if you want data entered in one field1 to appear in field2 go to the After Update field in the properties window for Field1. Change it to say Private Sub Field1_AfterUpdate ()...

Quick post to say thank you. Your answers really sent me in the right direction. I wanted to post a thank you Gemma the Husky I did need the Tables as you suggested – now I have. What you said about Points and Quarters being the same thing was right. A bit like splitting Managers and...

Hi Micheal. Still working on your LEFT JOIN suggestion. I'm trying to learn INNER and RIGHT JON too - just to see what that means. Also, I've been looking at Association Tables and Many-to-Many Ralationships I have realized, there's a lot to learn all about what Access can do and how it...

I find, sometimes, just writing out my question for this site, leads me to the answer - then I don't post.

Thank you very much indeed for your answer Michael. I will to exactly as you suggest. And then learn as much as I can about LEFT JOIN too. I'll report my results back on here. Best wishes Steve C

tblInvoice should have a One-to-many relationship with a tblTwo Field called tblInvoiceID All the devided (sic) cost manhours (sic) materials and so on would appear on a Subform to tblInvoice – no need for a button – it’s all there on the screen in one Form (and Subform). What did I miss...

What's a ticker?