Search results for query: *

Autoexpand is set to yes SELECT tblProjects.Projectname, tblProjects.ProjectID FROM tblProjects ORDER BY tblProjects.Projectname;

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

Does anyone know of any glitches to upgrading an access 2000 application to 2007?

I can't see how that would work. I have to populate the top with the location and the side with the items. each of these are from tables that can change. i almost need to integrate or link to an excell spreadsheet with the converging rows and cloumn headings as fields as well as the cell.

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

Thanks for your input, and I am thinking of the relationships, but we also have to keep in mind this is an Access DB and not SQL, sometimes to keep the speed for users up we need to duplicate some data and i still have to worry about the differnt prices for different customers.

i was trying to avoid creating the table structure because I hate to type, and there are alot of fields in the table. But really I only have to do it once so I should have done that in the first place. i understand your comments and I have struggleed with doing it this way. What it is we are...

...Try again", vbOKOnly Exit Sub End If strTableName = CmbCustomer.Column(1) strTableName = "tbl" & strTableName DoCmd.CopyObject , strTableName, acTable, "tblitems" strSQL = "DELETE *.* FROM [" & strTableName & "]" DoCmd.SetWarnings False DoCmd.RunSQL strSQL DoCmd.SetWarnings True End Sub

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.

You cam merge and append individual tasks by using a key field when mapping the import. I do this between an Access DB and Project.

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 can press f8 but it just loops back and forth beteen the stop and first line of code each time it is pressed. Yes there is no error messages. Thanks for the thoughts. I will try the decompile option. I have always had trouble with error handling, will try that option as well. I know you...

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 figured most of it out, I had to put the net folder shared calendar as a sub folder of the primary calendar and use the below code. i still get an error at the end that but setting the warnings to off works. i will continue to refine and see what happens. my next step is to figure out...

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