Search results for query: *

Hi all I have a sheet in which in coloumn Q i have either an "X" in it or the cell is empty. I would like to code that when i execute it all the rows which have an "X" in the according cell are hidden. I coded it like this, it's working but it is very clumsy, bascially I would end up having a...

Have a table like this: UL-Ticker 3WHigh 3WLow Boll1 Boll2 ------------------------------------------------- AMGN 33.50 29.10 32.00 32.50 ADEN 61.05 58.10 62.05 60.10 at the end it should look like this: AMGN ADEN 3WHigh 33.50...

I have a table with: Date balance 12/05/2003 3 12/18/2003 7 12/29/2003 6 01/06/2004 9 01/12/2004 5 01/26/2004 4 02/03/2004 7 02/21/2004 2 The query should extract the last data entry of each month with the respective balance like...

Hello all in another thread i learned that there is a possibility to have a running sum in a query and that it is possible to get it worked even without an ID-field. I want to have a running sum with dates as unique identifiers. It lookas like this: Query name: MTA_signal Fields: date, ticker...

Hi all Designed a DB on my laptop. The DB compacts itself on exiting. Worked fine on my laptop, but now since the DB lies on a server (it's a frontend/backend solution) i get the message on exiting "Table 'TempMSysAccessObjects' already exists" and the DB doesn't compact. The result...

Hello I designed a database which is split into a frontend (which every user has stored locally on his c drive) and a backend (which is stored on a shared drive/server). I originally programmed it under Windows 2000 professional and everything worked fine. A few days ago every user upgraded to...

Hi all Have set up a simple login procedure for my database. Created a table where username and password is stored. When a user logs in the database my code checks if the entered password matches the one in the table. That's it. For updating reasons i only want to have one user logged in at...

Anyone ! On a form i have a button that opens the open file dialog box and after selecting a file path I want it to store that filepath in a textbox on that form. I so far have the the button functioning and the open file dialog box opening, but getting the filepath to display in a textbox and...

Hello all on my form 5 different listboxes appear depending on what is selected in a combobox before. After that fields are being populated after doubleclicking on a line in either of the listboxes. Strange: With the first listbox everything works fine but when i try to do the same with the...

Hey all in a form i have a combobox where the user selects the category. The selection determines which listbox appears (i did it with a SELECT CASE statement and .visible=true/false) I placed the statement in the AfterUpdate event of the combobox and i call it in the OnCurrent event of the form...

Hello have been reading through all the similar threads but still can't manage this to work. here's what i have: In my form "ABrep" (source is table "Bway") i have a listbox which lists all the entries from table "Away". The listbox shows the entries in the...

Hi all Have a Form called "Offers" in which - depending on selecting the product category first in a combo box - the following subforms may pop up. The subforms are called "Offers_IP", "Offers_FM" and "Offers_MTA" and contain many different fields...

Want to wrap text in a MsgBox. I use the Chr(13) function to wrap it. But I always get a compile error: project or library not found. Am i missing a DLL or something? Any clues ? Chris

Hi.Have a form with a combo "cboproduktekategorie". Based on the selection in this combo i want to become another combo (either "cbofm","cboip","cbomta","cbodd" or "cbodiv") visible. i have set the five combos' visible property to false...

Hi. Have a combobox (called "Produktekategorie") where one can chose between FM,IP,MTA,DD and Diverses. In the next combobox (called "testcbo") one can chose between E and F when FM is chosen in the combobox "Produktekategorie". But when IP is chosen in...

Hi, need help please with a client database. Have a combobox in which one can select from A,B,C and D. In the same form when selecting "A" the 2nd combobox appears where one then can select between E and F. But when in the first combobox B is selected, in the 2nd combobox one then...

Hi all. Designed a client relationship DB, with which I'm super happy. Have beginners knowledge in Visual Basic, but no clue abt SQL, or so. Now i want to distribute the DB to my employees in a way, that: * they cant change code/forms/reports... * that they can only open the front end of the...

Hi all. Designed a CRM DB, with which I'm super happy. Have beginners knowledge in Visual Basic, but no clue abt SQL, or so. Now i want to distribute the DB to my employees in a way, that: * they cant change code/forms/reports... * that on their desktop is a icon which opens just the front end...