Search results

Hi. I am going to upscale my backend to an SQL Express server because of corruption that occurs due to the way our network is set up. It is not possible for me to change the network setup. The backend is relatively small in size (5mb and growing). Its updated with the access frontend by 10-15...

Further evolvment Private Sub cmdDial_Click() telefon.SetFocus DoCmd.RunCommand acCmdCopy Shell "notepad.exe", vbNormalFocus Sendkeys "^V", True 'its all good DoEvents Sendkeys "^a", True 'it was case sensitive. So small "a" worked. Sendkeys "^%+d", True...

Update to coding. The question remains the same, I would like to send CTRL+ALT+SHIFT+D. I doesnt matter where I send it. As a "quick solution" I've added a command that opens notepad, then pastes the telephone number. This works. Now I need to "mark" the same number I've just pasted, probably...

Hi. I have a split DB, with frontend and backend within a citrix environment. All users work from within the citrix environment. We have an autodialer application (outside citrix). When i set focus to a number, and hit CTRL-ALT-SHIFT-D I automatically dial the customer. It's a nice function...

It was to good to be true. Thank for clearing that up!

Hi. I dont think Citrix is relevant for my question. To simplify my question; will an accdb created in msaccess 2010, automatically get "MS Access2013-sql benefits"? And Will my frontend still function as normal (only faster since the engine now is sql and with less likelyhood of corruption)...

Hi. My application is made with MSaccess2010. It has multiple users, a split front end, and all users (and db) is on a citrix terminal server. This works great (enough). Backend accdb, frontend accde. However, I see the need to upgrade the backend to SQL server and keep the frontend in access...

Thank you so very much! The problem is now solved. The biggest problem was actually to get the filesize small enough, but still within access limitations. First i converted each pdf page as png. Because most of the pages are white, that eliminated a lot of the file size. I then compressed it...

Hi. Thank you for your reply. I have looked at kallals solution, and it seems alright. The former version of my application used excel for the same feature, and it worked really good. I assumed Access would be able to do the same, There must be some solution to this problem! I think, however...

Hi! I have a DB that is split to a back and frontend. The FrontEnd is published on a Citrix server, so is the backend. It works well, but I have issues with images in report. We have a lot of suppliers that demand that we use their standardized forms for entering customer information. Most...

solved! Thank you! I added a value to the query which said year0, year1 and so on based on a loooong iif sentence. After this i replaced the form controll to this field rather than the actual year, and it works :-)

Hi. I have a little "y2k issue". My DB has many (!) forms that are based on Crosstabs queries. The headers are years, and therefore my formfields has controlsources like 2014, 2015 and so on. Example: The table it comes from looks something like this: tblProject Project: Myproject Value: 1000...

Anyway, thanx for all the help. You have really been a great resource!!! The problem probably lies in the controllsource. The db has several flaws, and I am going to rewrite the entire DB, especially the quiz part. If I figure out the problem I'll let you know :-)

No, still the same debug message. When I click a forms property, I go under the "data" tab, and the first line there indicates the recordset which is QryQuiz_Klargjør (a query). The form works great if I do the job manually, tab through it and punch the first letter in the initials... Let us...

I have a commandbutton next to the unbound field, and when the mousebutton releases, the code runs to magically fill in alle the comboboxes in the continuous form. A programmer just looked at the coding, db-structure and so on.. He was in a hury, but checked the debugger, and couldnt find any...

I have a commandbutton next to the unbound field, and when the mousebutton releases, the code runs to magically fill in alle the comboboxes in the continuous form. A programmer just looked at the coding, db-structure and so on.. He was in a hury, but checked the debugger, and couldnt find any...

I'm hopeless.. Your assumption is correct, VLini is the agents initials, and also the value i want to appear in the box. You are also correct about the form being continous. I think I got the line under correct... (should return the correct VLini) !QryQuiz_aktivAgentJA(VLini) = Me.inputINI...

Hi. Yes there is a controllsource for the combobox: SELECT VL.VLini, VL.TESTaktivert, VL.Aktiv, tblSYS.DBstatus FROM VL, tblSYS WHERE (((VL.TESTaktivert)=Yes) AND ((VL.Aktiv)=Yes) AND ((tblSYS.DBstatus)=Yes)); Yes, there is a datasource for the form. I have used a leftjoin relation in a query...

I dont get any errors, it just fills the value in the first box and stops there. The other rows are left untouched. I have som more code in the form for logs etc. They shouldnt be a problem, but what do I know...(?) The code I got from you is at the bottom. Private Sub Form_Close() Log...

Thanks ajeTrumpet... it almost worked out perfectly. It inserts the value into the first row, but doesnt "finish" the whole 80 questions. Can the code be modified so it will finish off the whole 80 questions? Private Sub Kommando11_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As...