Search results

Guys, When I manage to bypass the shift-key, I can still import the tables and queries from the database through an external source. Any idea how to prevent this? TiA, Timo

Hi, This should be pretty straightforward, but I do not seem to succeed. How do I pass the value of a combobox to a function? This is my current code: Function UpdateDealer(iDealer As Integer, oDealer As Integer) 'stuff End Function And this is the code behind the button: Private Sub...

Ok, solved it by removing the 'Const' strPath 'as string' and replacing it with a Dim + strPath = "stringzzz"

Hi David, First of all, thanks for your help. Then: Now I get a compile error. "compile error: constant expression required" Let me start with the beginning, because it goes wrong on the first line: Function Rebuild_YTD(iYear As Integer) Dim i As Integer Dim iPrev As Integer Dim...

thank you, this works indeed! Question: right now I am plugging a lot of SQL queries into VB. Running them one after another as a series of updates. Would there be a more clever way of doing so? Thanx, Timo

Hi, Up to now I have to say this forum is The Best! Found só many solutions here, all in bits and pieces of code! Thanks you all, for posting here. Now, I have a small, little problem. I want to update columns in a table, 1 by 1 (12 months in a row). This is the code I use: UPDATE...

Hi txGeekGirl, thanx for your reply. Am I correct when I say that if I give read & execute-access to a user on a folder, in order to use an accde-database, they can alter the data? That is for me how it seems to be. What I want to do is to have a user-login for some people to have read & write...

Hi Texas Geek Girl, Your files look very appealing. I have a database which I would like to assign read & write or read-only rights, based upon the user logged in into Windows. We're in an enterprise environment and it would be very interesting to get this to work. Can you help me out? With...

Hi Rx_, Thanx for your reply. Dealer ID is unique, indeed. How would you build such an error-check routine? Currently it is not allowed to append a dealer ID that is already there, so I first have to copy the old duplicate into a tmp-table, append the new information, check if this is a...

Fixed and working. For all of you having the same concept/problems: A bunch of randomly named Excel files with a strict format (template) are imported into several Access tables. I have 2 sheets (sheet 2 & 3) that I need information from to be imported, I have 1 sheet (4) with 2 variables that...

If I would use this, would that come in close? I mean, would this delete the customers from the contactlist and their records from the list with items (dealerlist)? Then afterwards I would import the excel sheet containing the customer contact info and material info. 'Get the counter &...

Hi, I am building this database, importing several excel files from different customers. The excel files are standardized. Every month or so they give updates. Then it is up to the database to update the old tables with standard info coming from these excel files. Now I am looking for a way to...

Hi, First of all I want to thank you all for being this forum. It helps me a great deal in my first steps into VBA. Right now I am looking for a way to update a record in a table with information, read from Excel, if the record already exists. If not, it is an append. How could I do this...

OK, so far so good. First solution to store a value in a variable was given here: http://www.access-programmers.co.uk/forums/showthread.php?t=236762 Although not 100% correct, it helped me getting started. So, solution no. 1: 'Get the counter value Set objApp =...

*EDIT: see 3rd post for solution/solvation Hi, Right now I am building a database with items, coming from local dealers. We send them a locked excel sheet, which they feed with dealer information and item information. In the excel sheet, this is being separated (in the background) in 2...

Hi, I am totally new to VBA coding. The above challenge I need as well, to read the value of 1 cell in a random excel sheet. Would one of you be so kind to help me out in here? This is my code: Sub Link_To_Excel() 'WillR - www.willr.info (December 2004) 'Macro Loops through...

Wow SpentGeezer, *Thát sounds easy* :p Merci Beaucoup, going to test it immediately

Hi, Right now I am setting up a database to import 'random' Excel files, placed in a certain folder. These files are set up as follows: customer can fill in a certain table (unlocked cells in a locked sheet/workbook). second (invisible) sheet copies values from customer sheet, from row 1 to...

cool, sounds it is not that difficult, after all :-D Thanx!!

thanx! Works. [shows my complete ignorance/incompetence towards VBA coding already] :banghead: And I am learning; this is interesting. Step next; since it's a "runcode" in a macro, I can pass a year onto it, don't I? So, how to replace "2004" by 'the year filled in in the macro'? Original...