Find Jobs
Hire Freelancers

Access Database form and report

$30-5000 USD

Concluído
Publicado há mais de 14 anos

$30-5000 USD

Pago na entrega
I need a couple of Access Database forms and some Reports built. It needs to be added to an existing application written in Access, and the back end is SQL Server. The software is the back end for an internet business. It downloads orders from the web, and allows us to process the orders. At the end of each day, we update the status of each order, some of the statuses = "Order Backordered". Each order is tracked in two tables, one Order, which has common information that one would collect about an order. The other table is Order Details, this table contains one line for each item ordered. Today, we can tell which orders are on backorder, but not which items on the order. The form will record this information. There is some followup work for a couple more forms and reports after we get started, and we can add those using a private auction. For now, I need the following form and report: ITEMS BACKORDERED FORM I need a form that will cycle through the orders from today (I'll show you how to get those records) and display each item ordered on the screen. The form should have a checkbox that the user will check, and the check will indicate that the item is not in stock. The form should also have a button that the user can push in the event that all items are out of stock. The form will record the out of stock condition for each item, and store the checkbox state in a field in the Order Details table. The user will press a next button, and the form will cycle through all of the records selected. When the form is opened, it will also calculate an identifying code, and it will store this code with each of the records, and it will also store it in the Order table for that order. Think of it as a purchase order number. Also, the form will update a couple of fields in the order detail record from info in the order record when the backorder info is saved. PACKING SLIP I need to modify the existing packing slip so that an asterisk is placed next to the item if the item is on backorder. ## Deliverables There is one more thing. You will need to VPN to my computer, and do your programming directly on our system. We're on the EAST COAST of the US, and you can work during our daytime hours. I'd like to choose a coder tomorrow AM, and begin work tomorrow AM. This is relatively simple, and I would expect that you could finish the two changes by end of day tomorrow. I will show you the tables, and everything you need so that you can get right to work. I need this right away, so your availability to begin will be a significant factor in your selection. Also, you need to be available during our regular business hours. Thanks very much! George
ID do Projeto: 2829950

Sobre o projeto

2 propostas
Projeto remoto
Ativo há 15 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
See private message.
$212,50 USD em 14 dias
3,8 (27 avaliações)
5,2
5,2
2 freelancers estão ofertando em média $319 USD for esse trabalho
Avatar do Usuário
See private message.
$425 USD em 14 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
United States
4,8
34
Método de pagamento verificado
Membro desde mai. 31, 2001

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.