Recent content by adi2011

Sorry for that. BR, Adi

Hi, I plan to create some kind of Hybrid application, and I have a plan, but I would like to consult with someone who has more experience than me so I could avoid possible major mistakes. I plan to create ASP.NET Web application (MSSSQL) which will end-users use for Ordering products. I...

Is it possible to link Excel file with my Access 2013 web app? As far as I know, I were able only to import Excel data and that is it.. That is why I am looking solution via Data-macro. Thanks in advance. Adi

Hi, I have excel file called "Products" which looks something like this ----------------------------------- ItemNo. Description Price ----------------------------------- 1 Tennis racket 100$ 2 Tennis ball 10$ In my access 2013 web app I have table "Products" which contains...

No problem, I will follow these guidelines in future. Best regards. Adi

Hi London_CJ, yes, you are correct, my case is emergency to me so I decided to post it on few different sides in order to get differend opinions and quick answers, I hope. If topic on this forum is problem of any kind, please close it. Thank you and best regards. Adi

Hello, In my Access 2010 desktop database (DB) I have VBA code behind form "Purchase orders" which task is to calculate current stock of the item. It is set-up on AfterUpdate event of combobox and looks like this DSum("[Entry]", "Q_StockEntry", "[ItemNumber] = " & [ItemNumber]) -...

Hello, I am using Microsoft Access 2010 hybrid App which contains three tables which are connected to Sharepoint list, and the rest of tables are offline. When user opens Access 2010 desktop version, I have set up command which does same thing as "File>Sync All" option BUT Sync All means that...

Hello, I have access 2013 offline desktop database (DB) created for everyday business (materials managament, sales etc). I have approx. 50+ forms/tables/reports. I plan to put one part (5%) of that DB online. That 5% is component called „Purchase orders“. In order to do that, few tables which...

Hi Ben, I don't understand, I really have many records on that date.. It is not Null for that particular date, I am 100% sure. BR, Adi

Hi, I have simple crosstab query that I use to pull data about how many products is selled in one day/week/month and so on. On entry form I have two critical date fields, Starting/Ending date. It all works perfect except when I put indetical values in both those fields. For example I have...

Hi, in my database (db) I have first create simple report which can print label for certain article in number of times user wants to. That part of db is marked as OldLabels in db that I have attached bellow. Now, I plan to update this code via form NewLabels so user could choose more than one...

Hi, in my database (access 2007) I have code similar to this Dim Ulaz As String, Izlaz As String, UkKol As String, UkFin As String and at the end of the code I have this Me.NC = UkFin / UkKol Me.NC respresents avaerage price. If for result I have 0.498 value, I would like for that value...

Thank you very much for your suggestion. I have made changes based on your suggestions and here are some important updates: - I have split database to FE and BE, - I have made copy of every FE on 10 user PCs (yes I had to install it on extra 6 PCs) and I have placed BE on server. These are...

Hello, I have a large Access db (300 MB at least) which is located on server. It is called patients.mdb and it is a Access 2003 version. This db is used by 4 PCs: 1. PC i - Win XP - Office 2007 2. PC ii - Win XP - Office 2003 3. PC iii - Win XP - Office 2003 4. PC iiii - Win XP - Office 2003...