Search results

It runs perfectly on my laptop and my desktop, but always gives run-time error 5 on 2 of my co-workers computers. This is where it stops. Can anyone help please? Thanks! I have checked reference on all computers made sure they have the same order. just checked again, we have the same versions...

I need to send a weekly report at 11pm every Friday night to someones email. I think there are 2 things I need: 1. automatically generate a report at that time. 2. automatically send an email with that report attached. (maybe 3. attach the report to email, I've never done it:confused:) Right...

I recently upsized my database to SQL server, after that I created a Access Project(.adp ) to replace the original one(.mdb). I thought that's the proper way to use Access as a frontend... My issue is that I had a table that linked to outlook inbox in my original one database(.mdb), but now...

I've created a ACCESS database and upsized to sql server. Users run it from a mapped net drive, basically a shared folder. In this way users can access to this program without getting on the server, mainly because of safety issue. In my program, Access and Outlook are connected. It can...

I recently unsized my access database to SQL server. I will store tons of documents, pdf, mp3, pictures in the database. My plan is storing all documents in folders which categorized by document type, then store location of the document as hyperlink in the database. In this way I will not have...

Runtime error 3251: operation is not supported for this type of object. debugging says ".AddNew" is where the problem occurs. Can anyone tell me how to fix this? Thanks

I'm new to VBA I just want to return the result to a field called Date how do I do it?

I've setup some users for my database using Tool> User-Level Security Wizard. I'm wondering how do I ask users to change their passwords every month. Thanks

I want Access to read the fresh part of an email but not the old replied content. What i mean is I want Access to only read the 'fresh' part of the email, for example 33333333333333 in this case. But I couldn't find a way to do it...sad... Now I'm thinking if I can let Access only read the...

Is there a way for access to continuously monitor Outlook (sending/ receiving) and store email data in database?

I'm linking Access to Outlook, the system automatically generated a link table called "inbox" which I can't modify anything inside, seems like a 'read-only' table which shows emails' information in Outlook "inbox" folder. The very last field in the "inbox" table is called "content...

I'm linking Access to Outlook, the system automatically generated a link table called "inbox" which I can't modify anything inside, seems like a 'read-only' table which shows emails' information in Outlook "inbox" folder. The very last field in the "inbox" table is called "content...

I keep getting this error Run time error 2501 This SendObject action was canceled. This is my code: Can you tell me where went wrong?

I have a function that calls out filter. It does his job well, but when it can't find any match just returns a blank page with nothing on it, so the only way is to close it and open it again. I'd like to have a warning or reset to it's initial state when it can't find any result. How do I do...

I keep getting an error: run-time error '2185' "you can't reference a property or method for a control unless the control has the focus." There is no problem with CheckFilter function, I checked. My Code: Thanks

I have a table set up like this ClassID (pk) ClassName ParentClassID And of course another like this ItemID (PK) ClassID (FK) ItemName for example, ClassID ClassName ParentClassID 1 .........Vegetable.......null 2 ......... Meat............ null 3 ...

I created a form that contains 1 subform ( lets call it lvl 1 subform) in which I created another subform( lvl 2 subform). lvl 1 subform acts like a child to the main form, works well, it returns each equipment's corresponding component type. lvl2 does the same, returns all component...