I have an unbound form and an unbound combo box that has a query as the row source. I can not get autocomplete to work. The 1st field in the query is text, indexed and unique. I know this has worked for me in the past, does the for have to be bound? I created a whole new form just incase it...
I have a cell in a excell file that comes from a customer and I want to be able to pull the payment and the date out of the cell and then enter both in an access table.
the cell looks like this
Awaiting Payment($1004.260::01/10/2009::0)
I can get the strat of the amount with the left...
I currently do not have the licensing to produce or use the grid control nor is it likely management is going top purchase. i am tring to build a form and resulting data table that can work like a grid. I'm trying to build an estimator for construction that will list all the items in a table...
I have a master item table that i am tryong to set up a listbox that once selected all the items would be moved to a new table with all the fields of the master table. What i am currently doing is copying the master table with a new name to get the structure and then deleteing the items within...
Does anyone have a good suggestion for a pocket pc database that i can snyc with an access db? i have looked at several, but can't seem to find anyone who is using them to get opinions. Thanks in advance
i have a treo600 using outlook 2000 w/o an exchange server. i can get emails to delete from the handheld once deleted from the desktop, but why wont it delete on the desktop once I delete it on the handheld.
Is there a way to local all the references needed on a network drive so when I depoly a split DB I know up front all machines will have access to all the referendces they need.
We have GPS on all delivery vehicles and the service currently sends a customized e-mail on several events to any e-mail account I wish, however it would be much more efficent if I could have the email program call a number and give a prerecorded message. It would be ideal if I could customize...
This smay be the wrong forum, but i have a routine in MS Acess 2000 that inserts an appointment onto a shared outlook calendar, and I was wondering if anyone knew how to find that record in outlook to retrieve back and edit. I have a form that does some job scheduling and when the job goes...
Thi smay be the wrong forum, but i have a routine that inserts an appointment onto a shared outlook calendar, and I was wondering if anyone knew how to find that record in outlook to retrieve back and edit. I have a form that does some job scheduling and when the job goes longer than expected i...
I get this problem off and on and I'm hoping someone can tell me what I am doing wrong. I have a form or control that is working fine and then while add more code, usaually something to handle something I didn't anticipate the user doing. My current issue is between two combo boxes. I have...
I have found several helpfull post here to achomplish what i am triiing to do.
1. Trying to add calendar item to outlook from access.
2. the calendar needs to be shared with all, no-exchange.
3. The calendsar needs to be the same on all computers because all the individuals add, edit and delete...
I have a database that we are using on our lan for orders and a separate DB for the web store. What i would like to be able to do is "Snyc" the item table so i only have to enter items once. i have copied the entire web DB to our lan and automated filling the item table initially and then copy...
I am trying to draw vertical lines between textboxes that flow between sections of a report and are connected throughout the detail section. I thought i saw how to do this, but have either lost the link or lost my mind. is this possible in Access, I have done it in crystal very easily, but...
I have a report based on a query that returns 172 records, but only prints out 99 records. It is formated to ledger size paper and printed out in booklet format. I have the detail section set to grow, as well as the main memo field in the detail section to grow. i have reduced the size of the...
I have a routine that changes several items on the record and for external pictures, I want to put in a option after the user changes the combobox to revert back to the original choice. i have a message box asking if the really want to change in the on change event and if they select no i want...
Has anyone attempted to put the back end of an access db in the offline file use mode for windows xp? i have been reading up on it and it looks like it might help a bigger db to move faster, but I am concerned about multiple useres at the same time.
All of the computers in the office are working on Office 2000, execpt 1 it has office 2003, but does not include Access with it. Can i load Access 2000 to that computer from our other office 2000 cd, oh by the way it is the only one that has anymore licenses on it anyway.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.