Search results for query: *

hi all I have three colums on one sheet and four on the second sheet. 1st sheet is master copy- has over 5,000 records. what I want to do is match the 2nd sheet with the first and if a match bring in the 4th column or otherwise put a 0. This is my code so far, but I just keep getting errors...

hi all linked to earlier query but a separate problem so have logged it by itself. using visual studio - have say 6 fields across top and two fields on next line. As I have had to add a table is there anyway I can make the 1st field on the 2nd line cover say the 3 fields on the top line - eg...

hi all I hope I'm in the right forum here I am using ms visual studio / sql query ok I have a field as below call field to Material Charge field is a 1 to many relationship =Fields!MaterialCharge.Value if a call has more than 1 worktime entry - this shows separately with a 0 balance - eg...

jewel (TechnicalUser) Jul 27, 2004 I have started a new project - ODBC connection This is the first time I have used the project side - so was surprised to find no query window. Moving on I see I need to do relationships in the Diagram window. I have a call table - primary key (field...

I have started a new project - ODBC connection This is the first time I have used the project side - so was surprised to find no query window. Moving on I see I need to do relationships in the Diagram window. I have a call table - primary key (field CallNumber) and a worktime table - (has a...

hi all I am from an access background - we are starting to user MS Visual Studio.net with the query info being done in sql Query Analyser. As I haven't used these before I set up a project in Access but am having probs. Can someone point me to somewhere that will explain sql query analyser...

hey all I want to set a button for users to open an xlt as an xls - this is my macro so far Sub saveas1() ' ' saveas1 Macro ' Macro recorded 17/05/2004 by Dianne Dalton ' Workbooks.Add Template:="H:\Word\Template\Tape.xlt" Windows("comp list maker.xls").Activate Workbooks("comp...

hey all I have been given a project to have a look at - have been using VBa in access but not too sure about excel. They have a .txt file exported Headings= Title: Clip Type: Blank: In point: Out Point: Duration example lines as below GOLF/RVO/6PM/08#1 GOLF/RVO/6PM/08#1 Deb Edits...

hi all not sure if I have the right group but hopefully someone will tell me. If a .bat file is run username=ddalton where bat file is updating to userprofile: C:\documents&settings\daltond so obviously no files were updated because of the name. is there a line we can add into the batch...

not too sure how to approach but here goes we have a compiled exe file - made up of numerous files. this generates a form with drop down boxes using parameter files in csv format - at the moment only allowing the first letter to be effective - how do I change the code to allow the next letter to...

hi all not too sure how to approach but here goes we have a compiled exe file - made up of numerous files. this generates a form with drop down boxes using parameter files in csv format - at the moment only allowing the first letter to be effective - how do I change the code to allow the next...

hey all has anyone had a problem with the above? if you disable DHCP no problem - dont want to give static IP if possible. cheers Dianne

hey all Hopefully I can explain this properly I have an IP address (not a fixed) that I can ping - shows computer plugged into network - but the machine name does not show on our Active Directory. Is there any other way other than either shutting down or setting up another machine with same IP...

hi all We have Outlook XP installed with Office 2000. We want to use the small business tools. change for SR2 office loads only the Customer manager and Business Planner but does not let you load or see the Financial Manager - has anyone else come across this please - I can install this if I...

hi all - posted 16/6/03 - anyone can put me in the right direction would be helpful updated Access 97 to 2000. if clicking into a field box cannot sort - eg go edit find - just comes up not found. I struck this with another that I had updated and it ended up having to "update all input...

hi all updated Access 97 to 2000. if clicking into a field box cannot sort - eg go edit find - just comes up not found. I struck this with another that I had updated and it ended up having to "update all input masks in the form" manually while in 2000. But I don't seem to have any...

hi all if choosing to use HTML mail format - the auto correct does not seem to work - is this correct or is there something I am missing? works in rich text! can someone let me know please cheers

hi all I have a form based on a table for data entry 4 fields name position monthid year After keying data into each field - enter on last field brings up an new record and focus is in name ready to enter data again how do put the focus on the name field please thanks Dianne

hi all I have a table with auto number - long integer I want to run a query just bringing out say 30 records that are not in consecutive order eg id no 32, next id no 37 how do I put this in my criteria field If I put it in "" it looks at it as a text field and then tells me data...

hi all I use to use NT/Office 97 and the following code worked fine on a command button Private Sub excel_Click() Dim xlapp As excel.Application Dim xlbook As excel.Workbook Dim xlsheet As excel.Worksheet Set xlapp = New excel.Application xlapp.Visible = True Set xlbook =...