Search results

Hi, First of all, let me put you on context. I have 2 SharePoints: The Master SharePoint from whom I can only read data, and an owned SharePoint into which I have total control. What I have to do, is to read some entries from a list on the Master SP with an Access database, process it some how...

Hi, I think that I'm stuck in a glass of water, but I've been trying to do this for a couple of hours with no results. Maybe you can help me as I'm not an experienced VBA programmer. I'm trying to show the data retrieved in an ADO recordset, in an unbound subform. I do this to get the data in...

Hi all, I have an issue with an Excel file that I'm generating through a VBA code in Access. I generate a report of some data that is in Access 2007, on an Excel file and add a "processing view" button to do some operations. To add that button, I add a module to the Excel file in this way...

Hi all, I've recently developed an Access 2007 application, that creates a report in an Excel Sheet. Now I need to put a button in that sheet to switch from one view with certain columns, to another one with other visible columns. I have the view switching code writen in excel, and I can...

Hi all, I'm very concerned about the error message I'm getting, because it seems to simple but yet I haven't been able to solve it.... What I'm trying to do is to make an Access file, that is going to be used by many people, that gets some accounts information (basic info as name, group and...

Hi all, I'm very concerned about the error message I'm getting, because it seems to simple but yet I haven't been able to solve it.... What I'm trying to do is to make an Access file, that is going to be used by many people, that gets some accounts information (basic info as name, group and...

Hey, I've tryed to insert a row in an excel sheet that I filled through an Access Table. Everything is ok with it, but when I try to use the generated code after recording a row insertion in excel, I get the following message: Object doesn't support property or method My code is the...

Hi, I'm trying to do something that may not make sense at first sight, but it has, haha. I have a List Box in a form, that serves as an attachments list of an item. I managed to make it record the complete filepath of the files that I want to attach to a mail that is being sent by the form...

Hey, I hope you can help me with this one, I designed a tool in Access 2007 that updates every week using another Access 2007 file. The way I do it, is creating this updater file with a form that has a button that has some saved export steps to the Main file. It works OK, for all the users...

Hi, I hope you can help me with this one. I have an access form that gathers some information, and allows the user to attach files in a field (an attachment field). With this info, I want to send a Mail through Outlook (Problem solved) and attach all the inserted files as outllok...

Hi all, I was hoping you know how to enter some data (e.g. a Password) in a column, using an encrypted/encoded format (lets say, something in VBA like varpw= MD5("mypassword"), so you can later do INSERT into users (user, password) values (varusr, varpw)) I need to have some kind of...

Hi All, What I'm about to ask may seem pretty basic, although I Haven't fount it's answer yet.... What I need to do is to evaluate a condition like: If (PL = "X" or PL = "YT" or PL = "PG" or PL = "WL" or PL = "ZO" or PL = "QL") Actually, is like that but with 22 "ORs". It works but it...

Hi all, I'm pretty new in Access 2007 and I've just created a table that needs to get data from a form (That I also created). So, I open the form for the first time, entered a few data (I've used the "record Operations" --> "Add new Record" & "Save Record" buttons) and saved/stored them in...