Search results

All, Good morning. I've searched the forums for an answer to my problem but still being a novice I haven't found anything that makes sense to me. I have a main form that contains Work Order information. Job #, date, customer, PO#, etc. I have a subform with all of the detail of what to do...

Hello all, I have a report that has 3 subreports in it (expenses, hours, and costs) per job. I have them hidden and have it grouped by customer then by job as I've been requested to create a summary report showing the above in groups. It's running and calculating fine however in the group (by...

Hello all, I have a database that we've been working in for years. We have a purchase order table (form, etc) as well as a work order table (forms, etc) for all the jobs in house. I've been asked to set it up so that up to 10 work orders can be linked to each purchase order. I went into...

Hi all, I have a query that I just can't figure out. We are a facility that works on rail cars. We have over 200 cars in house at the moment and the database has a daily production report in it with the status of all of the cars. I need a query that will pull out the "AAAA" and "XXXX" cars...

Hi all! I have an access front end database with an SQL backend that resides on the server. I need to add a field to the Employee table that links to a folder for each employee on the server that contains their training docs (word and pdf). I created a text field but don't know how to get it...

Hi all. Just a question. Is it possible to run an access front end and a sql back end (on the server) on a tablet for access in a large plant? Wifi is available. If so...what tablet? Windows 8? Thanks for the tips!

Help! I did some work on our database yesterday...adding reports and some queries. All was well. We have a sql back end and access 2013 front end. The DB was originally written in Access 1997...ha ha. Anyway - all was well...replaced the front end on everyone's machines but after shutting...

Hello all, I searched around the forums and couldn't find what I was looking for. I need a pop-up form that is based on an if then statement. For example if there is a certain customer selected on the form and the detailed bill is more than 10 lines long (I have a count field) then I need a...

Hi all! I hope I can explain this right and I'm not sure if it's even possible but here it goes. I have several tables. A job table (customer name, job number, item number, etc) and a job detail table (description of the repairs, codes etc) which can be up to 80 lines per job). The job...

I have an Access 2010 Front End with SQL Express (I think) backend. I've recently updated the front end of the database. For some reason now I get this error on a query and in a form, "OBDC-connection to SQL ServerSERVER\SQLEXPRESS' failed. When I refresh the tables - everything works but I...

Hello all, I have two combo boxes. One with the customer and one with the customer contact. These boxes seem to be working fine however, after you select the customer and then the customer contact box updates, it isn't allowing me to choose the contact. Nothing happens when you click. Can...

Hello all, I have a query that's been working fine for years, however...the powers that be have requested a change. We need to track the lining owners in cars. We've recently gone to SQL on the back end (which I basically know NOTHING about) but I set up the new table, refreshed the...

Hi all! I have a cscading combo box on a work order form that pulls the contacts from the customer selected in the main box. It's working fine, values are printing fine on the reports, etc. however on the form itself - when you change from one record to another....the value is not displayed...

I have an invoice form that has a subform with line items in it. Each line item has a date field in the table because we partial invoice sometimes. We have a new customer that can have up to 70 line items. I'd like to somehow auto populate that field with whatever date I type in or by ticking...

We are changing our employee vacation compensation from an annual basis (every January) to an annual hire date accrual. This code is working fine... =IIf([Text208]>240,"160.00",IIf([Text208]>120,"120.00",IIf([Text208]>24,"80.00",IIf([Text208]>12,"40.00","0.00")))) [Text208] is months employed...

Hi All! Thanks to all your wonderful help I am slowly but surely getting there with our new database re-write!! I'm trying to calculate a field in a query and having some syntax problems. Here's what I have.... MLabor: Format(Int(

I have a delete query that runs fine when you click it but if I set-up a macro to run it from a button on a form I get errors. Is there a better way to run it? Thanks!

I'm trying to export query results to a text file and it keeps giving me a "too few" parameters error. Can anyone help?

Hello, I am trying to redo some major sections of our database however, I am completely self taught and we just switched to a sql backend so it's not necessarily easy for me. I made a copy of the old database and went to town on the new one. I have a macro that runs a query that deletes all of...

Hello all, I have a form with a Text Box in the detail (Text100) which contains the following =