Search results

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...

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...

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...

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...

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...

Hello, I have a rather odd problem with MS Access and bullzip. Im converting one by one report (invoice) to PDF with bullzip. The whole process in Access goes without any errors. However, sometimes I get the error message from the title in bullzip with the next text: "Error -2147024864: The...

I run into a weird problem. Im building my front-end in .accdb with Access 2007 and the back-end is a mixture of SQL Server and .mdb. However, in this particular case only the .mdb database is being used. Running a simple append query from VBA, (Im copying records from the back-end .mdb table...

Hello guys, Recently I came across this problem and couldn't really find a solution on the internet so I decided to share my experience about it here. I made an invoice access report which contains a memo text field in the report footer. However, whenever the text would be longer than 255...

Hello guys, Im looking for the fastest way to print text data. Instead generating 20000+ pages in a report (with logos and stuff), what would take quite a while, is there a way to print text data directly from VBA? I would include only text data, logos and other images, if any, would already be...

I run the same report on 2 different machines (one is windows 10 with access 2007 12.0.4518, and the other one is Windows 7 with Access 2007 12.0.6735). Regional settings are the same. There is a number field which has the standard format #,###.##. On the Windows 10 machine the 4 digit number...

Set Radnik = MyDb.OpenRecordset("SELECT LDRadnik.JMBG,Radnik.ImePrezime, Raspored.Koeficijent, Radnik.BrojGod, LDRadnik.IznosNe1, LDRadnik.IznosNe2, _ & " LDRadnik.PorManji, LDRadnik.DSPO, LDRadnik.IznosIsp FROM ((Radnik INNER JOIN LDRadnik ON Radnik.JMBG = LDRadnik.JMBG) _ & " INNER...

I had a similar problem to this one in another thread I started, however this one is slightly different so Im writing a new one. Well, my UPDATE query fails in VBA with the error "ODBC - update on a linked table "table name" failed" The query is pretty simple: "UPDATE tmpRacuniZaEksport INNER...

Hi guys, My problem is that Im getting the error from the attachment when running my code. The error probably happens because the code query didn't manage to update the field/s within the given timeout which is 60 seconds, but thats not the real issue. When I execute the exact same query...

Im developing the .accdb at my PC which has Office 2007 and Office 2010, Im using Office Access 2007 for this .accdb. On my PC in this location C:\Program Files (x86)\Common Files\Microsoft Shared\VBA I have VBA6 and VBA7 folders In Program Files (without x86) I dont have the VBA folder...

Hello, Is there something like a shortcut for doing this instead going through every query, form, report and code line for fixing them with the new name of the table? Thanks

Some strange thing is happening. The report crushes on opening, but not always. As it seems only if the query which the report uses is "big". I did the debugging but it doesnt crush at any of my code lines but at the very end, when the "End Sub" is executed. This is all happening in Office...

Strange things happening with one of my .mdb files. In one table, there are records which cant contain a Null value but they do and have ### instead real value (screenshoot in attachment) I replaced the database with a backup one but then again same happened when the same records had to be...

I saw somewhere on the internet that I could link the SQL Server tables to my .accdb with VBA, without having to use the Linked table manager. Sometimes I get the ODBC call failed when trying to link tables with the Linked table manager and then I have to add every table again to the .accdb...

I get this error/warning (check attachment) when I make an .accde from .accdb. It jumps after closing the .accdb or .accde when doing compact n repair (turned on to do it on exit). When I open the .accdb and close, nothing like this happens, nor for the .accde after its been made. They work...

In the attachment I have put the query design. The qryNaplataKarticaSaIdPotDom alone runs just fine even tho the table has over 1m records. However, when I do a LEFT JOIN like in the attachment with this query and the table ImportNap, then it takes more than 3min for the query to load. When I...