Search results for query: *

There are loads of companies, and in turn, each company may own many domains. How do i create a query that will produce the domains of a single company, rather than all the companies and all of their domains? there is hundereds of companies, so obviously i dont want to write a query for each...

i can insert the calendar onto the form, but how do i get the date to appear in a box? for example, Registration Date: i want the user to be able to select a date from a calendar, and then that date will set in the Registraion Date box. ta CharlotteR

is it possible to set a date by having a caledar popping up / inserted to the form? thanks CharlotteR

i want a query to produce all the different passwords throughout the database - FTP Username & Password, Email sername & Password, Dial In Username & Password. ive made sure they are all Text, but its still yelling at me! grrrr! CharlotteR

i keep getting the message "Type mismatch in expression" whenever i create a query, either through the wizard or manually. its on a simple select query. any ideas? CharlotteR

(1) preferably a mix of characters and numbers. either set it as 2 numbers, 2 small case, 2 higher case, or whatever really ... (2) ok - will try and explain this more! a FTP Username is entered in the Domains form. what i want is for that username (whatever has been entered by the user) to...

is it possible to create a randow password generator into a form in Access? also, is there a way of: entering a Username in one form, and that being the automatic default for a different username in another form? thanks, CharlotteR

thanks to u all that helped. i have now found this on advisor.com: Listing 1: Open and shut case -- The main form closes itself as it opens the second form while the second form opens the main form as it's unloaded. 'In the main (switchboard) form: Private Sub cmdOpen1_Click() DoCmd.Close...

thank u!! it works wonderfully! just trying to find a solution to the second prob now! cheers

thanks - that makes sense, but i diodnt create the database, so have no idea how to get into the SQL part of it. or do i just need to go into the VB part of it? this is the vb code i have for that button at the moment (created by the wizard): Private Sub Command30_Click() On Error GoTo...

(1) i want to create a button that will open to things at once - two different reports. can anyone tell me how to do this? i couldnt find it in the wizard, but maybe im being thick .. (2) when the user clicks a button on a form to open another form, i want the original form to close. then when...

ive created a basic form, which loads data from a Customers Table from an Access Database. this works great. when i add buttons such as First, Last, Prev & Next, it all goes a bit mad, with the following message appearing: An unhandled exception of type 'System.ArgumentException' occurred in...

i am creating a vb.net project that accesses a database from MS Access. once i have finished it, will it be possible to then add/remove/manipulate the database from within the VB project? i want to be able to do more than just view the database through visual basic, and its not feasible to...

I have worked my way through a Microsoft book on connecting to an Access database. I have connected to the database, created a Data Adapter and a DataSet, all correctly. However, when i Run the program, the InitializeComponent() causes a problem. The message says "An unhandled exception of...

im attempting to create small program with a message box appearing but am having trouble with the display.caption bit: Private Sub Test_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Test.Click Dim testmsg As Integer Dim Display As testmsg =...

Im just learning how to use VB and though im using VB.Net i only have examples from VB ver.6 Anyway - im attempting to create small program with a message box appearing but am having trouble with the display.caption bit: Private Sub Test_Click(ByVal sender As System.Object, ByVal e As...

Can I create a form in Access so that when data is entered, it will automatically bring up further information? For example, the Customer ID (from the Customer Table) is entered. How could I bring up just the Domain ID which is in the Domain Table? I need to link the information over into one...

hi I have created several different forms, some of which contain the same information. For example, the field Domain ID is in both the Customer Form and the Domain Form. Is there any way of only entering the data in once under one table/form, and then linking/transferring it to another? Or...