Search results for query: *

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

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

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

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

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

Currently I have a macro which grabs a line of data from sheet 1, and pastes it say to sheet 3 on cell A1. I am trying to make the macro on the next run, to paste it in 1 row down and not affect the data in cell A1, I know you can do it, I just can't work it out... please help.

I am pulling some logins from a switch through crystal X, however I want it to display not the login but a name in my crystal reports. What formula do I have to do in the formula area to make this happen

I need to grab some data from a list which contains the dates in the form dd/mm/yy HH:MM:SS, however I need to Vlookup against the dd/mm/yy only, how do I get rid of the HH:MM:SS. I have tried to change the format and obviously this aint gonna work. please help

Im trying to run a macro which will pick date A and Date B and give me the data inbetween the 2 dates. Im using the below macro, but doesnt seem to work on the line in which starts the autofilter Sub DateSelection() ' 'This macro will ask for the date from an input box' ' Dim mycriteria...

I have a front sheet with some names on it, and I have created a control box for the user to pick a name. I then have a macro which grabs that name and does a criteria search for some data on another sheet based on Name and date. However, if for that date, the name picked has no entries, my...

Help!!!!! Can someone help me with this problem. I have some autofilters on sheet 1 and one of the filters filters by date, I want some vba code to say that if cell A1 = 01/01/05, then go to sheet 2 and find the cell in column A that has this date and then copy the whole line to sheet 3...

If I have 7 rows eg monday, tuesday etc down to sunday, Im trying to write a macro so that each day it copys the top 6 rows and drops down by one row, so my top row is now sunday and my bottom row is satrday Is there a way to write this type of looping in a macro?