Search results

Thank you!

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

I probably didn't word all that right. Basically there are many tables full of data and codes all pulling information into the job detail table. If they send a .txt file to pull into the job detail table is there a way to do it without creating duplicate values in all of the tables pulling...

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 posted in the SQL section. Thanks!

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

Yes - it says ODBC--connection to 'SQL ServerSERVER\SQLExpress' failed. When I refresh the linked tables all is well. But I have to refresh constantly.

It's too big BUT I've narrowed down the issue to another problem. Everything works fine BUT I keep having to refresh the SQL backend linked tables. Why?

Thank you! I believe I got it! Now I've run into a different issue. There is a subform on the main form both linked by the Job number. The subform contains all the details of the job. It seems to work fine and when you preview the wordorder report the data is all there however, when you...

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

Will work on that! THANK YOU SOOOOO much!

Namliam - that worked!!!!!!!!!!! This is a huge production schedule. It shows cars in out plant, the status, where they are and lots of other info! How can I make that a drop down field in the query as they use this query in datasheet mode to enter the data. Should I turn it into a form?

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

I can't - it's huge and split into Access front end and sql back end. Can I post the front end and have the forms work without data?

Mine is set up exactly like the video however iff you add a record, select the fields thenreturn to the record, the data in the sub box isn't seen.

It works but doesn't display the data after update even though it's there.

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

Would an update query work?

Is there a way to have click a button and have a pop-up box ask me the invoice date then populate all the fields in the lines with it?? I STILL have not gotten this done.

Ok - I'm having trouble figuring out how to "bind" it!!! I GIVE UP! *pulls out hair* Help!!