Search results

I have a form where I can select different cities to display local customer info for that area that is inputed by an office worker in that city. I use a query that lets you select which city to display info for. With the help of this forum, I figured out how to display the current or local...

Thanks for all the input. I will work on those suggestions today. Just got in.

Thanks for your kind reply. I am not sure that date function by itslelf will do the trick but I will play around with it some. I'm thinking I may need a macro or something listing all the cities with their respective time differences somehow, but I don't know how to begin doing so.. I guess I...

I have a form that displays various cities information for my firm. Each record is a different city and the form displays information for that particular area from a querry and users can input/update this info. I would like to show the local time for that city somewhere on the form. (I would...

Thanks for the reply, I will give it a try.

I have a form where I need to open it based upon the present date. The query has a date field in it. Each day is one record and cannot be dupicated either. So basically, I want to be able to have the form open and point to either a new record - Now()- and also reopen and point to dDate=Now()...

I have a form that tracks daily data and auto sums this data for the day in another area on the form. I would like to display the montly totals as well for the month that is presently displayed on the form. Is there way to do this without using a querry. I would like to simply calculate this...

When I attempt to append linked tables to my database I get an error message that indicates an INSERT INTO query cannot contain a multi-valued field. The linked tables are identical and should work. Is there a way to append a table that contains multi-value fields? I have spent a lot of time...

Thank you for your kind response. Would setting up linked tables from all the users I described to one main db work as well. In my scenerio, I wil have 18-19 users that will be using the same data base but with their own data - they will not need to see anyone elses data either. However, the...

Any ideas? I created a fairly large DB and now want to deploy it to 20 other locations around the US. Is the best way to use SharePoint 2007 or is there a better way. I was going to install the DB at all the locations as a standalone but then thought there must be a better way such as...

Thanks ChrisO. That looked a little too complicated so I took out the border all together . Wasn't sure how to apply your suggestion either, sorry. THanks anyway. I was hoping there was a way to format a rectangle without having to run a macro.

I have a report where I have several text boxes and Labels that I would like to place inside a rectangle or something similar so that they are enclosed together in the report with a nice border around them and will stay within this border. The rectangle needs to shrink or grow around the labels...

Thanks missinglinq.... I will give it a try later when I have a chance to work on it again. I was using the gotocontrol to highlight SchoolID field that sorts the school logs in the querry. I take it the first code you show does the same thing. I'll use your code instead.

I have a form where I enter and update data for dozens of different schools. I have a button on this form that opens up another form (using gotocontrol) that I call 'SchoolChronologicalLog' that is used to enter phone calls and other ongoing communications for the displayed school into a table...

I have a form that I need to lock the field (text box) after I enter the data (and unlock it if I need to update the data). I don't want to lock the entire record since other data in the form is changed periodically. It would be nice if it could lock during a save function. Any ideas? Thanks

Thanks for your help. I tried it and doesn't work for some reason. It looks like it should though. Going home, will try again tomorrow.

Does anyone know how to attach more than one report to an email using the embedded macro? Can you run more than one report per sendobject command? Thanks

Thanks spikepl I used the Format function in front of the field name and placed the long date items in the order I wanted. Thank You. It took a bit to figure it out but, now I know how!!!

I tired that before and it still only displays the short date. My Control source entry is as follows ="text"&[DateField] &"text" . The long date displays in my query and will display in my report if the control source is just DateField - without the text part, but then switches to the short...

I have a report that I want a long date placed within the control source such as " " & [Date1] but it only displays the short date 6/7/11 instead. Is there a way to display the long date in a report when you place the date field inside the control source location with other expressions. THank you.