Search results

Hi, I have a strange problem. I have some (small) embedded pictures on my form. For some reason after a while (during which I continue to develop my database, swichting to design view and back), suddenly the pictures are gone! Well, not entirely gone, but instead of a picture they are totally...

Hi, I have the following problem. I want a query to look up a certain (1 month) lagged valuta-return EURUSD. My SQL-code is as follows: SELECT qryValuta.RecordDate AS RecordDt, DLookUp("[EURUSD]","[qryValuta]","[RecordDate]=#" & DateAdd('m',-1,[RecordDate]) & '#') AS LaggedEURUSD FROM...

Hi, I have the following problem. I want to use the DMin-function and I want to fill the domain- and criteria-section with a variable which is declared in the module. So, I want to do something like this: I have three queries qryProductFood, qryProductTools, qryProductElectronics. All...

Hi, I am looking for some information about spreadsheettypes when you export from access to excel. For some reason there is only little documentation on this. I want to know what the several types do...

Hi, I have some VBA-code and at a certain point I want to close a specific file. Actually I want to close an Excel file which name and location are known to me. I think I need some code that checks wether the specific file is open and some code that then closes this specific file. Is there...

Hi! I got a small question (once again). I have a fairly complete database which workes just fine. I have some modules that calculates stuff. Now these modules were set up by my predecessor, and she placed in the top of all of these modules: 'Option Compare Database'. As I am not an...

Hi! I have a tiny question which I am insecure about. I want to replace the following code: (the code makes a certain table empty) DoCmd.SetWarnings False strSQL = "DELETE FROM TestTable" DoCmd.RunSQL (strSQL) DoCmd.SetWarnings True by the following code: strSQL = "DELETE FROM TestTable"...

Hi, I am a bit confused here, somehow I cannot see the way how I could do this. I have a form where you can enter several numbers, then you can press on button1 or button2 which both start the same module that processes the entered data. The button1 and button2 calculations are almost same...

Hi! Got a small question, I looked on the internet but couldn't trace much info regarding my problem here. Is it possible to display a MsgBox with e.g. three lines of text? So, not: text1 text2 text 3 but: text1 text2 text3 My current code is: MsgBox text1 + text2 + text3 Where text1/2/3...

Hi, I have a query which contains many nested IIF-statements. Due to that, my database is running terribly slow. I want to use a 'SELECT CASE' statement because I think this would be faster. In order to get used to the SELECT CASE-thing I created a new database and I implemented a query with...

Hi! I have a table with 2 columns, 'year' and 'month'. I want to create a query which creates a date from these two numbers. In the design view of the query, my current code in the field-cell is: Datum: DateSerial([SELECT Year FROM QueryTotal];[SELECT Month FROM QueryTotal];1) QueryTotal is...

Hi! I want to make a button on my form which opens Outlook and places certain e-mail adresses at the right places. I have a small problem though. My current code is as follows: Private Sub EmailButton_Click() Dim strToWhom As String Dim strToCCWhom As String Dim strMsgBody As String Dim...

Hi guys! Got a small problem. I got a big Access-form (big of size) but a small computerscreen before me. I am very much used to scroll up and down with my mousewheel. However, when I open my file and the opening-form pops up I cannot scroll up-and-down the form using my mousewheel. Is there...

Hi everyone! Got a small but mind-breaking question. I am rather new in Access so perhaps I overlook a small thing or whatsoever. My problem: I have a form built up off tabs. Under a tab there are serval sub-forms. Now, the problem is that when I open the file the tabs are hidden under the...