Search results for query: *

I'm using code to create a crosstab table for me, this is for scheduling multiple crafts by date, tally the time and post it in a form. Problem is not all crafts are schedule each day, so any craft not scheduled will not create a field in the crosstab. What's the best way to determine if a...

I have a dump from a system that I'll need to break apart into around 50 individual tables. I'll need to do this a few times a year so I wanted to automate the process. I'm down to the final part of the program and I'm having a brain poof. I want to copy a whole record out of one table and...

Hi all, I've been tossed into a well fire with a water hose to put it out. Seems I've been placed in the I/E design group to clean things ups. The guy before me kept multiple copies of drawing in tons of locations and I have to straighten it out. I've use ACad since the early 90's and Access...

Hello again, I have a subform in a tabular format that the users add and remove data. Also is the ability to renumber certian records. So I ran into a bit of a problem and need a quick fix (I leave for five days after today and do not want to be called at home, otherwise I would struggle...

I have a db with multiple users and multiple tables. One particular table is a bill of material. In the BOM table there is a BOM number, BOM item number and a part number. When the user needs to delete a part from the BOM, I run a simple query in code that seems to work but is at times extremely...

I have a form that allows the users to make multiple selections and type in variables that allow them to do a search. When they click the search button, I build an sql string and use it as the recordsource of a form that opens with their results. On rare occasions the user would like to print...

I knew this was coming but I avoided it until now. I have an Access db that started very small and has grown very large. There is a small group of us entering and editing the data, so it is easy to control. Now there are about twenty more people that want access to the data, read only rights...

I have a db that has been modified over and over again. What I have is a form for entering new data, the controls are all unbound. When the data input is finally completed, the user will click a button and the data checked before adding to the table. The table has far more fields than is...

I learned some thing new today, if you make a copy of a linked table, it is still a link. And in the process I wiped out some good info. IT people are restoring yesterdays back up, but I want to build something that will automatically back up tables for me. I have a db that is split into three...

OK for the past few days I have tried to familiarize myself with MS Project, but I am not grasping a few things here and could use a push in the right direction. I have a project that will take approx 12K man hours to complete. Its data entry so its a fixed amount of mhrs. Everyone is on a...

I have two tables, both are identicle field names and records. The first table is a base that never changes, the second is where the editing the records takes place. On a form where the people edit the second table, I would like to change the background color of any field that does not match...

I have a table in a db that is going to be shared by multiple users, each will have different criterea they will want to search by and none are familiar with Access. I have about 12 text boxes and 6 check boxes on a form that I would like them to set the search criterea with, click a button and...

OK, pulling my hair out here. I have a db with a field that contains a 9 digit number that I want to send in bar code to a special printer on LPT1. I have everything I need, fonts, conversions etc.etc.. I cannot seem to find a way in Access VB to send this to LPT1. Is there a special library I...

I would like to read a MS Word document map into code so that I may display into a sub form. Does anyone know what is required to read the document map or if it is possible.