Search results

Thanks, will probably do so. It's just that this locked table thing pretty messy, now I will have to check for tons of forms and txt boxes to see if they are locking other or the same table.

Hey guys! I'm having a pretty weird issue. My environment is an Access frontend application and SQL Server databases as the backend. I have a procedure which updates a set of records in a table [TableA]. It's a pretty simple update query, setting 3 attributes to 0, SQL is as follows: UPDATE...

I did that before but it didn't work, unless I include "SELECT TOP (then a random number just to be bigger than the actual number of records)". Somehow I didn't like that, I could put TOP 1000000, it will never reach that number of records but still.. No idea.. I have the .accde made for each...

The temporary table fixed it, however, when executing the append query I had to include the ORDER BY, without it it still messes up the rounding. Mysterious ways of MS Access 😵 Will leave it like this for now.. Thanks for the help

I will try to export my query into a temporary table and then use that same table to run my report. Yup, only math I run on the report is the SUM in report footer

Hello everyone, I have some pretty weird rounding problem or I'm just not seeing something. The situation is next. I have one table which keeps those amounts I need displayed on the report, and the field I'm fighting with is the tax one. Every record has a value > 0 in the tax column, there's...

I appreciate the suggestions and will surely consider implementing the same, as soon as I find spare time. I did check the "similar threads" section and found some interesting ways of doing it. I did try it quickly, I have put a txt file on the C drive from the administrator account and then...

Maybe I'm mistaken but I believe they do in this case scenario "Multi-User operating system". For instance let's take excel, the path to the .exe file is always the same "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" (Office 2007). Now every RDP user will use that same .exe file...

If I understood it right, your question is if every of the users accesses a copy of the FE just made for them? No, they all use the same FE .accde file, they all access that one same file. I did encounter problems with temporary tables but managed to solve it by creating a temporary table for...

The reason of the black screen seems to be related to the number of records. When I open a form in a "single form view" which has like 40k records after bringing back the app from minimized state to maximized the black screen appears for a few seconds but only if I'm on the last record or or...

As told to me it happened on 2 at pretty similar time, the third one was working fine. There are like 15 to 20 users all together

Suggestions for a better title are welcome. The environment: server is running Windows Server 2012 R2 and the front end application is located on it, as is the backend databate, mostly SQL Server databases. Office is 2007. Client machine is running Windows 10. The client is connecting through...

Looks interesting, I was thinking about doing something similar but didn't find time to do so. I get unrecognized database format error when I try to open the AFR_v375.accdb but will try another day with access 2010 and check it out more detailed. Thanks for the share!

For me something new and pretty weird. If I resize the access window so that my form controls cant completely fit on screen vertically the loading time of the form and moving between records increases from like 0.5 seconds to 5 to 10 seconds. Any idea why is this happening and is the only way...

There is also a database sample provided by Chris in the thread I linked above. InitialiseEvents is being called on form open. Option Explicit Option Compare Text Public Sub InitialiseEvents(ByRef frmThisForm As Form) Dim ctl As Control On Error Resume Next For Each ctl In...

Hi everyone, I found this older thread Change font color on ALL form controls on "Got Focus" and "Lost Focus" where ChrisO provided a pretty good solution. The only downsides I came across: 1) This procedure overwrites your current code on Got Focus and Lost Focus events if you have any 2) I...

Hi Pat, The part of code you quoted I wrote in my example. It has nothing to do with the cbo, I'm applying the filter to the forms record source, which is the query qryKontakteSortiert silentwolf, did you get it to work from the example I posted or are there more difficulties you are facing...

To be honest the idea of having a search field and a button for every record doesn't really look the best to me. Let me try to explain what I meant before, in more detail. First of all I would start by creating a new form, lets call it "popKontakte". (I forgot to mention that this form would...

How about the event "On Key Down" like the space bar? When the user has the focus on the cbo you could say something like, if he presses the space bar open a continuous pop-up form with all the contacts where you can search for the desired one. Once he found it and selected it on the pop-up form...

Added the DoEvents, set objects to nothing on the end of PrintInvoice procedure also set the default printer back to the original one after using bullzip. So I will follow and see if they report any new errors. Thanks guys