RecordsetJobs
... - EVENTS PLANNING - LICENSOR APPROVAL – It can be a table or just a status or trigger - COSTS & EFFECTS ANALYSIS – Table or report The attached diagram shows the relationships between tables, and since each table more or less represents the movement of data from table to table and vice versa with its recordset and document of the same name, it is controlled through the status of the recordset or document. The status is also tracked on the recordset if it has also been transferred to another table or the next step in the process or another document. In addition to operational tables, we also have tables that are essentially code lists, which are also shown in the diagram below: - MEDIA GROUPS - ADVERTISERS CRM ...
In an access mask I have 2 combo boxes. I need to connect to a db file (sqlite) and show in the first combo the recordset of a field of a table. In the second combo another field from the same table filtered based on the first combo. The rough work is enough for me, then I complete it
...di Sviluppo - Web Form e Asp.Net - Introduzione ai Namespace - Le direttive di pagina (@Page, @MasterType @Control, @Import, @Register) - Realizzazione Applicazione Web Form (e differenze con MVC) - Code behind (.cs) - Pagine compilate - - caratteristiche del e configurazioni personalizzate - L'Oggetto Application e Session - Utilizzo oggetti standard - Connessioni ADO, recordset e dataset - Gli oggetti gestiti da un'applicazione Web (WebForm, MasterPage, UserControl, WebService) - Post Back e Il Posting tra le pagine - Web template - Creare XML/JSON ed invio a webservice - Come pubblicare un progetto ASP.NET Con esempi pratici e casi reali forniti dagli studenti (ad. es. come impostare una form di Login "sicura", upload files, come importare/gestire templa...
...elérhető). A fázis I-ben (teszt környezet): *már kialakított és regisztrált (kb 10) usereknek önértékelést számadattal (1-15) *ill pár kérdésnél evidence feltöltést kell bevinni *mentési lehetőség megadott server elérési útra törtönik *lehetősget kell adni visszatérni a megkezdett de nem submittált feladathoz *a kész assesment benchmark feldolgozása, grafikus megjelenítése (dB struktúra, recordset minta, űrlap minták, tervek elérhetők). Tech: linux, mySQL, MariaDB, 7.4PHP, Apache, Joomla Platform 13.xx. Fabrik comp. PILOT alatt mindössze 2-3 ne...
IF YOU DON'T KNOW ASP CLASSIC - Please don't bid. Have an ASP Classic web page - need to add a text box in form that will autofill as you type the name - similar to the search box on page - Need to take MS SQL recordset of list of names to use for the content for the text box to find name. We will then post the form and pull the selected name from the text box. This project was started by another developer but their solution does not work so you will need to pull out what doesn't work and insert properly functioning code. *** Access to the server is not possible - so you will get the page and need to complete with that - send back completed and I will post to the site. the page that we need fixed is attached.
Overview ======== The Android SMS Gateway application will allow users to connect to a SQL Server database, retrieve a recordset of SMS messages, and send those messages. The application will mark each message as successful or failed and update the database accordingly. Additionally, the application will allow users to insert their credentials, start/stop sending SMS messages, and clear the log file. Detailed Description ==================== We require an Android application with the following functionality: A form that allows users to input their server name, database, username, and password. This information will be saved locally within the application. A second form with three buttons: "Start", "Stop", and "Clear Log". The form should clearly indic...
There are many many JSON files that need to be placed into an ms access DB table. Notes: 1. JSON files are from a local HDD 2. All JSON files are formatted the same. 3. The file name will contain the units serial number and needs to be added to the recordset going into the table. 4. Test file attached, Example of file name will be added after initial posting. The project needs to be completed using MS Access and VBA.
I have an unbound field with 3 fields: a) an ID b) a date c) a text I would like to update a table for the record with the same id than on the form regarding to the entries on the date and text field. I would like that this is done with the recordset method, not with a query. the work must be done by teamviewer. pay 10 USD.
i want to change a field-content with a recordset-method for a special record in the table. Work must be done now and with teamviewer. Pay 15 USD.
...'GB') $sql = "select * from bank_identifier where bank_bic like '" . $code . "%' and country_code='" . $country ."'"; else $sql = "select * from bank_identifier where bank_code='" . $code . "' and country_code='" . $country ."'"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_assoc($result); $description = $row["bank_description"]; } // close recordset mysql_free_result($result); // close db mysql_close($conn); // free mem unset($conn); unset($sql);unset($row); return $description; } function get_bank_bic_code($code, $country) { $bic=""; if(trim($code) == "" || trim($coun...
I have an existing VUE 2.0 web app that shows uploaded images. I'd like for the user to be able to drag images to reorder them. The callback for drag/drop would have to include info to update database with appropriate order. Sort Order is a field on the recordset. The existing app has buttons to move 1 spot forward back or send to the front/back but the end user wants drag/drop reordering. Max spend on this project is $130.
...i get Query time out for complex queries that i do when the Connection String contains IP Address and Port. But i do same complex query on same machine, using Database instance name directly, i never get timeout and it takes a second or two to run. Example : Query 1 : ConnectString = "Driver={SQL Server};Server=MSSQLSERVER5;Database=SchoolMain;Uid=Admin;Pwd=admin101;" When i use this query, recordset is fast. Less than 2 seconds. Query 2 : ConnectString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;Password=admin101;Initial Catalog=SchoolMain;Data Source=,1433" When i use this query, i get Query time out expired. Notes : > I am using same machine. For first query, i am connecting to MSSQL database directly and i do not need internet. ...
Without going into great detail about the actual code involved, I'll outline the steps required to create the recordset we need to build our Excel spreadsheet. Collect SQL Server Login Parameters (Server, Database, UID and PWD) Get the path to the .sql file with the Query SQL Validate existence of both the file and the SQL Server Use VBA to extract the text from your saved query .sql file. Create a Microsoft Access SQL Passthrough Query Set Query's Connect String, SQL, Timeout and Return Records properties Flag any DELETE and UPDATE queries. (Dissallow or run with password only) Execute the Access Passthrough Query into a DAO Recordset object.
I'm looking for VSTO expert . I have excel VBA code doing following . - Request POST API to retriev a data - Data is retrieved with TAB-delimeted string. - Creating the ADODB and Recordset - Parsing TAB-delimeted string into array - Populate recordset with an array . - populate pivotcache with recordset. Requirements - VBA will be converted into VSTO - and make a excel addin using VSTO. - Make a Ribbon-menu for "execution" . Only one milestone is allowed . and will be released if a project is completed.
I have a form with a subform, based on a select query. I made already a function that generates an e-mail. All what i need is the help to add the fields of the query (an order of procucts) into the body of the email. I think with recordset, but i don't understand how
Hello, I'm usign a Vba script in order to get data from SQL server, and used locally it working but when I'm using remote link doesn... sConnString SQLStr = "SELECT * FROM customer_table" Set rs = (SQLStr) ' Set formula calculation Manual = xlManual ' Check we have data. If Not Then Sheets("ArcaMag").Range("O1:T10000") = "" ' Transfer result. Sheets("ArcaMag").Range("O1").CopyFromRecordset rs ' Close the recordset Else MsgBox "Error: No records returned.", vbCritical End If ' Clean up If CBool( And adStateOpen) Then Set conn = Nothing Set rs = Nothing 'MsgB...
I require an access report built it represents a customer invoice. The required functionality is; a) A button is clicked on a form. b) A connection to sql server is made and a sp is executed and returned. c) The recordset holding the data from the database is used to populate the report and save it as a pdf into a local folder. The recordset will hold many ID's, and there will need to be 1 report (invoice) per customer in the folder. eg at the end of the run there should be x pdf files in the folder. d) The pdf will need to be named using one of the fields from the recordset. e) The report should not shown to the user. I have created the format of an invoice in Excel there is a header section, a detail section and a footer section, all of the data will come from...
Hi, I'm automating Word from Access, inserting data from Access tables at bookmarks. The document is about 25 pages and is moderately complex. I am going to need help with it for a variety of tasks including table formatting, conditional formatting, and TOC. The current one is display this list with bullet points. This is a simple loop of a recordset that inserts x lines at a bookmark but I need them bullet pointed. x =6 (varies per run) With objWord Set rs = ("MyList") for i = 1 to x . what:=wdGoToBookmark, Name:="MyBookmark" Do Until . . vbCrLf Loop end with Note: The position of the list in the document varies so this cannot be done by counting paragraphs from
...pimcore.com. It's not a specific project but is a 1-2 year cooperation (10-20 hour per week) Please review detail of pimcore before answer. In your answer/offer please include: - availability and working hours - experience in PimCore - availability to study pimcore from their white docs You will have to: - Install Pimcore in my server VPS - Set a GitHub account for update - Setup with me the data recordset - make for me VIDEO and White Paper of ANY modification you will do and share with me in order to fully document your job Set up of MDM Set up PIM Set of DAM Set up of transformation Set up of commerce Set up of CDP Set up of CMS Develop and customize PIM accoding to our requirements. 6 months project After that we will start the daily job in order to adapt the porgram t...
...with list of records; d. Form open/close, data entry/editing (validation) operations for sinlge record; e. Buttons, listboxes, comboboxes; f. Search functionality; g. Records sorting; h. AutoExec; i. RecordSet. 2. Create one report with at least 2 levels of grouping and aggregation functions;, e.g., date printed, page X of N, etc.; Requirements: 1) forms are customized, there is at least one form, where you can open single record for editing from list of record (Examlpe: form of individual employee can be opened for editing or for entering new employee from list of employees); 2) RecordSet and search functionality is used. I have a deadline until tomorrow morning. So, it would be great if you could help me finish it till the end of today. Thanks in advance and have a ...
...with list of records; d. Form open/close, data entry/editing (validation) operations for sinlge record; e. Buttons, listboxes, comboboxes; f. Search functionality; g. Records sorting; h. AutoExec; i. RecordSet. 2. Create one report with at least 2 levels of grouping and aggregation functions;, e.g., date printed, page X of N, etc.; Requirements: 1) forms are customized, there is at least one form, where you can open single record for editing from list of record (Examlpe: form of individual employee can be opened for editing or for entering new employee from list of employees); 2) RecordSet and search functionality is used. I have a deadline until tomorrow morning. So, it would be great if you could help me finish it till the end of today. Thanks in advance and have a ...
...with list of records; d. Form open/close, data entry/editing (validation) operations for sinlge record; e. Buttons, listboxes, comboboxes; f. Search functionality; g. Records sorting; h. AutoExec; i. RecordSet. 2. Create one report with at least 2 levels of grouping and aggregation functions;, e.g., date printed, page X of N, etc.; Requirements: 1) forms are customized, there is at least one form, where you can open single record for editing from list of record (Examlpe: form of individual employee can be opened for editing or for entering new employee from list of employees); 2) RecordSet and search functionality is used. I have a deadline until tomorrow morning. So, it would be great if you could help me finish it till the end of today. Thanks in advance and have a...
Hi! I need to find a partner to develop an application with pi...pimcore.com. It's not a specific project but is a 1-2 year cooperation (10-20 hour per week) Please review detail of pimcore before answer. In your answer/offer please include: - availability and working hours - experience in PimCore - availability to study pimcore from their white docs You will have to: - Install Pimcore in my server VPS - Set a GitHub account for update - Setup with me the data recordset - make for me VIDEO and White Paper of ANY modification you will do and share with me in order to fully document your job After that we will start the daily job in order to adapt the porgram to our specifications. ACTUALLY I DON'T HAVE SPECIFICATION so don't ask Will be paid hourly trough Freelancer ...
I have a TCPDF page with a PHP "while" loop that is supposed to create a new PDF page and print the corresponding data for each record in a recordset. The loop to create the PDF pages works but after about the 3rd record, I start getting multiple records on each page and it gets worse as the loop runs. I need help correcting this problem.
Hello I need a script to calculate an expiry date using an integer and an initial date. I have no experience with coding, but I tried the following code copied from a YouTube video; "Private Sub date_Post_Change() Me.date_Exp = Adddate_Exp(Me.date_Post, ) End Sub Public Function Adddate_Exp(date_Post As Date, txtVal As Integer) As Date Dim rst As Recordset Dim db As Database Dim date_Exp As Date Dim icount As Integer End Function" I attached a screenshot image of the form showing I am getting a result in Time instead of Date. I need the value in "Validity" to be added to the date in "Post Date" to give the Expiry Date.
Save recordset after sorting to database. Repair language switching.
...compliant) and each month automatically charge all the cards on file the amount due. That amount will be collected from a SQL query and matched by a customerID field in this program. There are a couple requirements: 1. Main screen: Get Current Charges Button This will run the query to get all charges accrued last month. I will provide the connection and query that you call. Just pull it into a recordset and display for review to the user. 2. The list that's returned should show CustomerID, CustomerName, Amount Due and a checkbox to Approve to collect. It should also query the table you create to store the payment information. If a payment type is about to expire or has expired it should highlight that customer in red. 3. The main screen should have another button ...
I want two root files one local in my /C/wamp64/www and the other in the server side root. I need to see the database with one simple table and one recordset. I will provide all the url's ftp UN & PW for the server side. If need be you can 'go into' my PC. For someone who knows what they are doing it's half an hours work. Knowledge of DREAMWEAVER CC is essential.
Need a small program written to call either a SOAP or REST API and retrieve a recordset and insert into a SQL table. The program will need to run on a schedule multiple times per day.
We have a gate access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of...access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of time. I would like to have a way to remove these unwanted records either in Access or in Excel and then import to Access. Within same username any record within ten seconds of the previous date and time would be removed. With the new recordset then have two reports created that recaps usage for a selected time. One report to show total record count by User and then a second report to show all usage within a date range and a breakpoint on username wi...
Build a recordset table using angular, php and mysql, able to change database connection, sort, filters, etc etc
Hello! I have a very simple problem. I have a button that sets a recordset based on a query. For example: rs = ("qryName") This query has a WHERE clause where I need to specify that the records are from a certain year. This year value is pulled from a control on the form the button is located on. For example: WHERE (Year())=Year([Main]![NavigationSubform]![txtYear]))) However, I get a run-time error because, to the best of my knowledge you cannot use a control in query that a recordset call is used in. I need help making it so my Query can access the value stored in this control.
I need a quick VBA routine written into a spreadsheet. Functionality as follows: 1. Read a certain column cell by cell downwards till the end of the data and copy all the values into a variable as a single string. (This is a SQL statement per screen shot) 2. Execute the SQL statement against an Oracle database (connection string to be hardcoded) 3. Put the resulting recordset, row by row, into sheet 1 from a predefined starting row. I anticipate this is a quick 2hr task for someone who has the right skillset.
Hello, I need a PHP developper that can write sample code in PHP 7! ( Version 7 of PHP because some code is obselete since version 7 for MS SQL driver) to call different types of Stored procedures in MS SQL server (RE...some code is obselete since version 7 for MS SQL driver) to call different types of Stored procedures in MS SQL server (READ: NOT MYSQL !!!!!!) A stored procedure with input and output parameters. Set values for Input and Read the output parameters after calling stored procedure. A stored procedure with input and output parameters and returns a recordset. Set values for the input parameters and Read the output parameters and the recordset returned by the stored procedure. I will give the description of the 2 types of stored procedures after you go...
I have a website that is designed already. This is an informational website only However, I need somebody to tie the registration forms and recordset view to BD and integrate payment. It's not a completed task. The DB we use is MS SQL, but you have to do this on your local server and send me DB/Table files after. This can be done in PHP The operating system is windows
Issues with the code below: current issue is I am trying to get the entire database recordset into the $message variable, it's placement currently means it's not looping through records and I can't think how to do it. So, I need the entire recordset, all fields and rows passed to the $message variable. <?php $servername = "localhost"; $username = "root"; $password = "yeahyeah"; $dbname = "transport"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM tmpdiscounts"; $result = $conn->query($sql); function ...
This project is to create a simple C#.NET application that allows a customer to choose search criteria (a variable and a value) and then searches FoxPro (.dbf) tables to find a match. When a match i...Carrier, Tracking #, etc. There may be no matching records, just 1 match or multiple matches for any given search. There will be a Next button, in case the user needs to continue searching after the first match. The data is contained in multiple FoxPro tables with identical structure. So, it will be a bit more complicated than executing a single query and cycling through a single recordset. Instead, there will need to be a loop which opens and closes multiple tables until it finds a match. (There's one table for each business day.) See the attached specifications f...
Using php I will like to query from a cryptocurrency exchange a certain recordset. The query must be fast and attached the task in notepad. A cryptocurrency exchange is a platform where users can buy and sell cryptocurrency, Their interface is accessible using API The records I have specified are public accessible records from the API.
La base de datos Access en 2016 da un problema de Recordset en el un formulario y no puede crear en el formulario nuevos registros (si en las tablas) en Access 2013 funcionaba todo correctamente
...out. The ticket system allows responses to the customer and keeps records of correspondence. A confirmation email will be sent to customer, but be aware not to become endless loop if the customer also has a auto responder. The admin will also allow update of certain pages like "how it works" Blog will be a simple blog to enter in articles to be read first page will show a list of articles with recordset paging and timestamp. These pages can be clicked and then all details can be read. visitors can also like these articles and there will be a tally. Example site of what we like site must be complete, including setup on hosting server(probably a virtual server because i dont think any basic hosting plan will allow url rewriting). within 30 days. Design will be created
I need someone to help me write a sql statment for below: I have two tables in a MySql database. In TableA I hold information about products given out for today and the group they belong to (if they belong to one), in TableB I hold a check list of all the products that should be given out if they are in one of the groups. TableA id Group ProductNumber 1 Grou... Group3 15423 5 Group3 14236 6 Group2 172883 7 Group1 198334 8 Group2 90399209 9 Group1 78877 Table2 I basically need to do this in MySql: Check to see if the product given out was the right one according to table B. In table A it tells you what group the ProductNumber should belong to, so if its in that group in tableB then its ok. If not then bring it back in the recordset. ...
I am looking for a sample rest API written in Python. The API should use: Python 3.6 Django Django Rest Framework Amazon AWS DynamoDB backend The API will be hosted on AWS elast...API written in Python. The API should use: Python 3.6 Django Django Rest Framework Amazon AWS DynamoDB backend The API will be hosted on AWS elastic beanstalk. I would like an API that can demonstrate: 1. How to create a table 2. How to insert into the new table 3. How to update a record in the table 4. How to retrieve a single record in the table 5. How to retrieve a list of records in one recordset The table created can be simple e.g. contain the following fields: ItemID (primary key) ItemName ItemDescription The deliverable will be a Python module that can be installed on EB to demonstrate the func...
Act...database(accounts) or in another bank database (Transfer money from bank1 to bank2). The purpose is to show the interoperability of XML. The 2nd bank stores the accounts in a database with the same attributes with the first bank. your bills by withdrawing money from your account. history. Display all the transactions a user has completed. ASP will be used to retreive the recordset from the database and send the xml document to the client whenever requested. I'm using the IIS web server. The deadline is for 14 september. Hope it helps. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code, with comments of all work done. Complete copyrights to all work purchased. ## Platform Windows 2000
I have an Access-DB where the user checks records he wants to mass-update. The routine is working fine if there are not too many records chosen, but if we choose about 50 - it times out and we clearly get a locking-problem. We have tried extending the timeout - with no luck We have tried batchlock and ADO-recordset - with no luck If you have experience with such a problem you might be the developer to help. And if you fix this problem there will for sure be more.... If you also know .NET please mention that - because we also have a webpage which can also need fixing....it works right now...but you never know.....
I have file which connet to SQL server from Excel VBA , However I get error message in "SQL Server does not exist or access denied" reso...GetSerialNumber() Dim status As String ' Create the connection string. sConnString = "Provider=SQLOLEDB;Data Source=;" & _ "Initial Catalog=SQL2008R2_919755_5010470;" & _ "Uid=SQL2008R2_919755_5010470_user;Pwd=XXXX;" ' "Integrated Security=SSPI;" ' Create the Connection and Recordset objects. Set conn = New Set rs = New ' Open the connection and execute. sConnString.... -------------------------------------------------------------------...
...B) Create a procedure/function to loop thru the recordset definited by qrstPrLy4AaK assigning the next code generated by the above procedure to the field, strAaK For example, if qrsstPrLy4Aa has 10 records, after the procedure is run: Record 1 now has AA in strAaK Record 2 now has AB in strAaK Record 3 now has AC in strAaK Record 4 now has AD in strAaK Record 5 now has AE in strAaK Record 6 now has AF in strAaK Record 7 now has AG in strAaK Record 8 now has AH in strAaK Record 9 now has AI in strAaK Record 10 now has AJ in strAaK Requirements: 1) Create procedures/functions in the attached Access database, dbJob013 2) Process should execute from the command button cmdTest on frmTest 3) The recordset above, qrstPrLy4aaK is define...
...letter code. B) Create a procedure/function to loop thru the recordset definited by qrstPrLy4AaK assigning the next code generated by the above procedure to the field, strAaK For example, if qrsstPrLy4Aa has 10 records, after the procedure is run: Record 1 now has AA in strAaK Record 2 now has AB in strAaK Record 3 now has AC in strAaK Record 4 now has AD in strAaK Record 5 now has AE in strAaK Record 6 now has AF in strAaK Record 7 now has AG in strAaK Record 8 now has AH in strAaK Record 9 now has AI in strAaK Record 10 now has AJ in strAaK Requirements: 1) Create procedures/functions in the attached Access database, dbJob013 2) Process should execute from the command button cmdTest on frmTest 3) The recordset above, qrstPrLy4aaK is defined by a sel...
We have an application in which users can create complex queries with many 'AND' and 'OR' , and aggregation conditions. We will be storing the representation of this query as a JSON string We need a .net function to which we will be passing this JSON String and the function should parse the JSON string and create an elastic search query and run the query and return the recordset.
