Search results for query: *

Please see the thread: Thread705-1765159 Bob Scriver MSU Spartan

I want to monitor a secondary Outlook account from ACCESS. I have a user with a second account that is being monitored in Outlook. If I change the Default account so that 2nd account is the Default I can perform all the actions necessary but I can't have it be the default account as they need...

I have a MS ACCESS 2010 FE and BE loaded to a pair of Citrix servers. The FE is loaded to a folder on the C drive of the server and the BE is stored on the server in a folder along with the WorkGroup. I have a linked table to the Outlook All Public folders area in a folder for the company...

I have a MS ACCESS 2010 FE and BE loaded to a pair of Citrix servers. The FE is loaded to a folder on the C drive of the server and the BE is stored on the server in a folder along with the WorkGroup. I have a linked table to the Outlook All Public folders area in a folder for the company...

thanks I was thinking I may not have the correct forum. Is it possible to transfer this question to the other forum? Bob Scriver MSU Spartan

I have a MS ACCESS 2010 FE and BE loaded to a pair of Citrix servers. The FE is loaded to a folder on the C drive of the server and the BE is stored on the server in a folder along with the WorkGroup. I have a linked table to the Outlook All Public folders area in a folder for the company...

Yes, I have run reports with pics and the pic file is embedded in the SnapShot formatted report file. I have found that the SnapShot option works really well. Our office had SS Viewers on everyone's computer and this afforded us the ability to send out canned reports via email easily. The SS...

That's a great idea with the Hyperlink. This saves on loading time to your database. By just using a thumbnail of the pic for the database it will speed things up. Good luck. Bob Scriver MSU Spartan

When you run the code what does the below code display? MsgBox "Path: " & CommonDialog1.FileName Bob Scriver MSU Spartan

I haven't been on the site for some time but the format that I posted initially was the following: Me![PictureImage].Properties("Picture") = Me![ImagePath] I think you have modified this somewhat and that me be causing your problem. Use the format above and see how that works. Bob Scriver...

dandot: I am no longer on a network to check this out but I believe this to be true. Normally, there is a back-end database that holds your changing data tables. In addition each of your users has a front-end database that has your static tables, forms, reports, queries, and modules. The FE...

Sorry but you also may want to display err messages or perform other code when it is not ERR - 3022. You will have to add that code. Just a reminder. Bob Scriver MSU Spartan

One of the easiest ways I have found to do this in a multi-user environment is this. Create a Unique Index(no dups) for the InvoiceNo field so that as you then monitor the ERR value in your error trapping code behind a SAVE record button. Here is some sample code that will update the record...

As I don't know your process, normally the InvoiceNo gets assigned as the record is created. That is the time to do the DMax function and assign the value +1 to the InvoiceNo field. You just must be careful that two people are not entering a record at exactly the same time and try to update...

It seems that the DMax function only executes against the original recordset within this query so it will not give you a newly updated Maximum InvoiceNo each time. So, we will have to use a subroutine to loop through the Null InvoiceNo's and update them individually. This code should work for...

Let's make another adjustment to the code I gave you. Clearer head this morning. Must have been dreaming about this last night. Query1: SELECT tblProjects.Project as Project, 2 as SortOrder, tblProjects.Year as Year, tblProjects.DateEntered as DateEntered FROM tblProjects WHERE...

Sorry about that, it is late and I am beat. Here is a correction. Use this SQL and save as a seperate saved query. Then create another query taking in this query as the input recordset and sort on your fields with SortOrder being the primary. Query1: SELECT tblProjects.Project as Project, 2...

Give this a try: SELECT tblProjects.Project as Project, SortOrder as 2 FROM tblProjects WHERE (((tblProjects.SiteID)=[Forms]![frmMaster]![ID])) ORDER BY SortOrder, tblProjects.Year DESC , tblProjects.DateEntered DESC UNION SELECT "All" as Project, SortOrder as 1 FROM tblProjects GROUP BY...

Change your Where statement to the following: WHERE InStr(1,TargetStr(),[tblProjects].[Project])>0 You only need to evealuate if the field string value[Project] is within the Target string. Bob Scriver MSU Spartan

Show me the SQL from your query and how are you using the function and selecting the records. Are you trying to use the Instr function to look for that particular value in the string? Bob Scriver MSU Spartan