Search results

I spent the whole day going around in circles on this too. You led me to it. Many thanks.

Thanks after all day. This led me to it.

Re: pURGE TABLE SOLVED Solved it Thanks

I've got my test dB working. So I need to purge out the data from a table with 900+ rows. Can I do that in one fell swoop. Instead of a row at a time?

I've wondered about that for decades. But ACT does a nice job of it.

SOLVED Thanks guys for the advice. I'll stick with it. I also use ACT and they have the 1 field thing working pretty good.

I was sure if my memory serve me right, it used to. Or at lease I used to use it that way. And the book clearly says it should.

I am using a canned download from MS to handle contacts. So I entered the mask > which is supposed to convert everything to capital letters. But nothing responds? I want to type with some speed and not worry about hitting the cap locks.

rather than typing in the time in correct format I thought the date & time pick pop-up was quick and mostly error free. They times are verified by the time sheet the employee hands in every day.

Ya - we get the time sheets a day late, or significantly after the work is done so NOW doesn't work. I uses a significant DB program (from a SQL platform I think)recently that had a date picker with start time and end time. Access and Excel both advertise a "Date/Time" format. Must be...

Time employee starts work. Time employee ends his day. Time a job starts and time a job is finished. Coming of their time sheets.

I can make the DATE picker work, but I need to add the TIME to the same picker. At least that would be preferred.

Maybe I need to be more specific. There must be a way for me? My data base has a form where I daily enter specific info to a project. When the project reaches a certain amount of time (hrs), it needs to come to a STOP and THEN reset or START (for example) 75 hours later. Not before! So...

Thanks for the suggestion, I need to be able to dial in or pick the time. I thinking your solution probably picks the current computer time. but I need to pick a employees end of the day time on their time card. ??

I can make the date picker work. I also need to be able to choose a time. How can I make the date picker include a time?

GRR - no kidding - good point to ponder Another is changing prices results in changing values of inventory. I think this is going tooooo far

This is a quite Greek to me. Never have heard of a "natural sign". Each part has 3 stages Incoming, On hand, and Sold to a department. So how does 1 or -1 handle that? Are you saying to handle all these process's in one table? We'll want to create reports of Vendors, dates of...

"For this reason as well as the lack of auditability, I prefer to keep separate inventory transactions. That way you can sum the transaction to determine the current balance." That's my thinking too. There is totally different required fields for the "Purchase Orders" and the "In house"...

I'm just starting the process. We have a parts supply warehouse whose contents changes daily. It's always "in flux". Staff come daily and need parts and supplies for projects. So items are going out of inventory. That's one event. Items are purchased daily and brought to the warehouse to...

I can build a table and form for our "Parts Inventory". No problem. I can build an "Order form" for orders that identify the parts. How do I get the "Order form" to delete the parts or update (reduce) the "Parts Inventory" table with the reduced products? Conversely I can build a "Form" to...