Search results for query: *

Sorry guys, let me be a bit more specific in the stuff i have since I'm a real noobie with Access. So i have a login form with the below Private Sub Command4_Click() Username.SetFocus If Username = "00897" And Password = "next" Then MsgBox "Username & Password Validated" DoCmd.Close...

Hi People, I have created a username/password form, i want to know for instance if the password is correct, how do i make the username bind to a parameter in a query? so the username = "mark" and password = "abc", how do i make it so that in the query, the username will then only query the...

Hi, does anybody know what i need to do or what VBA i can do to stop when i open up a form in access , it is autopopulated by the cursor? I have already locked them down but obviously this is not going to help Please help

I have tried to read and 'understand' other posts on the same question, but ... way over my head. I have a query which from some tables pulls revenue and then i have added the 'descending' in the sort, however what i want to know is how to add another field which provides the ranking within...

Hmmm, thanks for the above, but do any of you have any samples or sites i can look up , so that if the username and password are correct, then bind the user name to query in the form that will open if the username and password are correct. thanks

Hi, I have created a basic login form (below) with the person needing to enter a username and password So when the user enters the correct username and password, i need to know what i can do to make a [parameter] in one of the querys' to use the username that was entered Private Sub...

Hi, Recently with sql 2008 I went through some pain with transaction logs files exploding in size. There's many blogs out there on this subject but what was affecting us was something new (Change data capture) and is not widely documented. So first the basics: You should generally have...

Hi , I don't usually use MS Access, but just need some simple guidance. I have 2 tables, 1 with a field of say total volume, and another table which has a field with the total cost, all I want to do is to find out the cost for a day. they both have the date field in them, so I joined them at...

I'm trying to work out the following. - Have a table with - Name - contract expiry date I have then in a form added the above, what I want to also do is to add 2 combo boxes which are related e.g first box says " customer wants to update contract ( Yes or NO ), then if 'yes' the 2nd...

Tried that, still blank....... but yes your were right I did have columncount as 2 my table has the 3 fields; ID (PK), Country and city

OOps, yeah me bad.... - using 1 table , fields are ( country ) & ( city ) - 2 combo boxes, cbocountry and cbocity - in cbocountry, used SELECT DISTINCT tblAll.Country FROM tblAll ORDER BY tblAll.Country; in the row source.... In cbocountry 'afterevent' the following was put in...

Thanks for the sites, however, even when I follow the above code for the examples, combo 2 box does not show any lists based on selection of box 1........

I've been trying to figure out how to have 2 combo boxes on a form, but have the 2nd combo box only have certain drop down selections based on what was chosed in combo box 1. e.g If I have a table(table1) and have one field called Department and another called Name, If a certain deparmtent is...

I believe that installing MS Access Runtime enables multiple users who have not got a MS Access License to still use Forms... However , does anyone know what steps need to be followed to get this to work? Thanks

What if I only want them to use a form?

Hi People, Still quite new to MS Access, but is it possible to have multiple users use a form with the 1 MS Access License? I want maybe up to 8 people to be able to use a form at the same time and have the DB update the data Thanks

I have a table which as customer details eg. Name, contact information etc. There is also a combo box which contains ( still interested, no longer interested) I then have a form which has this combo box, the 'no longer interested is chosen, how do I make it so that this record will no longer...

Hi, I hardly use MS Access, but is there anyway to build a Form for multi users to use, but have them only see the form and not any part of MS Access? Also just a real beginners Access question, if I want multiple users on an Access form, do I need to purchase more MS Access licenses for each...

Hi, I'm new to Cognos 8 and have been a past user of cognos 7. The problem I'm having in 8 is being able to schedule the report to save to a directory eg in C:, it only seems to allow me to save into a directory folder within cognos. Can someone help me on this.

Can someone help on this ... currently using Impromptu and have had my access to the SQL are taken away from the dept, so the only way to create reports is to just drag and drop the tables. However, I need to search for some data and I'm using this in the filter. MSISDN in ( '0423345645') ...