Search results for query: *

I have this database. I am stuck with a problem.. I have this popup form that suppose to show the amount produce for a particular product for the whole week. I am not sure how to do this because I want to do is that each week the date resets depending the date.. Any help is appreciated ASAP...

Hi all, I have a problem that I cannot seem to fix it. Whenever I open a specific database I get the following error: The Microsoft Jet Database engine stop the process because you and the other user are attempting to change the same data at the same time. By the way...

You can use Data Access Pages to connect to the Database and collect the data you need... :-)

Private Sub Form_Load() Calendar.Today End Sub Private Sub Calendar_Click() Me!TxtDate = Calendar.Value end sub This should work... Hope that I help you with your prob.. Inform me if it doesn't work...

Hi all, I am stuck with a problem, I have a form called frmUsage, at run time the form is in a Datasheet view. I need to have a calculation of some of the materials not all.. For example in my form this is what I would have: Materials Usage Corn 1234...

All you need to do is change the format of the cell from numbers to text.. For example: right click on c1 and click on format cells, in the number tab select the TEXT option and click ok. Once you have done that type 003563. It will keep the format but it will align to the left so you have to...

Best bet I can say is to reinstall Office..

Is the computer connected to the network? If so, the only solution I have is the same as the last one I gave.. Basicaly, donot login to the Domain but to computer itself... I don't know what else to say... :-)

I ran into this problem numerous times. Basically, if the computer is on a network. Under the login, instead of your Domain name as the name of the domain why not change it to the computer's name and login as administrator. For example: (If your domain is called MIS and computer name is test2...

Urgent help needed.. I have a report which is called Physical Stock... The values in the fields are based on the date they enter.. I have a between date criteria in the Query. My problem is that I want the Opening field to take the first day of the month data while the Physical stock will be...

Why not try the after update event for the Price Executed textbox... Here is an example: Private Sub Price Exceuted_AfterUpdate() If Price Executed.value ="0" then Deal Executed = "No" end if end sub Hope this helped..

Private Sub Textbox_GotFocus() Textbox= "" End Sub Hope that this helps you...

Hi, MiggyD your suggestion was helpful but I have another question for you.. The DBase program we have is DBase 4. Is there a way to recreate the structures for the database without changing alot of stuff? The real problem is that the structures or tables are not working in Dbase 4 but works...

Hi All, I am not good with DBase program at all, but my company has a problem with one of the dbase program we have. The dbase database is not working in DBASE program but when we run with the Visual DBase it works but when the reports are printed, they are not printing properly... How can I...

I am stuck with another problem... Basically, what I have is a form which is called frmPhysical Inventory. The fields I have in this form are Opening Stock, Receipts, Usage, Computed Balance, Physical Stock and Variance... What I need is to automatically fill Receipts and Usage fields based on...

Private Sub Copy_BR_Button_Click() On Error GoTo Err_Copy_BR_Button_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append Hope that this can...

Um, I don't really wanna do that.. I am not gonna be doing so I need a code that actually just does the stuff off the bat for me.. (If you know what I mean?) :-D Any help is appreciated.. Thanx...

Hi All, I have a problem, my company have this batch system, the data from this system is downloaded everyday and its in comma delimited file for excel... Is there a way that I can import it to a specific table in Access.... and I don't need all the data I need every other column in the excel...

I am having a problem coding my MS Access database.. My clients are enetering the physical stock manually daily... What I need to have is that when they enter the physical stock of yesterday and for Today that same physical stock would be the opening stock.. All I need to have is to have to...