Search results

Hi, In MSAccess2003 this worked fine, in 2007 it doesn't.. why not ? Code: Private Sub Exportmail_Click() Dim objOutlook As Object Dim objOutlookMsg As Object Dim objOutlookRecip As Object Dim objOutlookAttach As Object Dim AttachmentPath Dim DisplayMsg ' Create the Outlook session...

Hi all, I have a form where I want to show three numbers: - Competitors who are member (they have Memnr) =Textfield 1 - The ones without Memnr =Textfield 2 - Total of competitors =Textfield 3 In Access2003 this os working fine. in 2007 the second field is displying "Name?" Textfield 1 has...

Hi, I have a query export to csv, which in A2003 works great. In A2007 it won't work (on same computer!), I read several posts about the export specifications but have not found the solution yet. This is line where the export is defined and then exported ExportScore =...

Hi, I have a calculation which is depending on three fields: VerzId, Kapitaal (currency) and Perc. If one of those fields is edited (let say user made a typo in the kapitaal field) how do I refresh the calculation ? So, whenever one of three fields is editted, the calculation should run again...

Hi, I got this piece of code but it's giving me error 13 : Types don't match.. Pointer is set to Set rec = Anyone sees what's wrong with this ? Private Sub Kapitaal_AfterUpdate() Dim intKap As Currency Dim SQL As String Dim rec As DAO.Recordset intKap =...

Hi, I got several queries which all can apply to the same field, I was testing with this: Private Sub Provisie_BeforeUpdate(Cancel As Integer) Dim Fee As Integer If Me.VerzId = 1 Then DoCmd.OpenQuery "ProvBerekGelders" Me.Provisie = Fee End If End Sub But it's not exactly what it...

Hi, Best to have a look at attached relations picture. Basicly this is what I'm wondering about: I add a new customer who bought a product from a specific supplier. That unique combination gives me the right on commission. From company A I get, let's say 5% of the capital. Company B gives me...

Hi, I want a datefield defaults value to be the first of the current month. DateSerial(Year(date), Month(date), 1) should do the trick, but whatever I try, it won't work...don't know where to set this. Tried the field props in table, props on Form, no luck so far.. Anyone ideas ? Thanks

Hi, I'v been reading a lot of posts, but can't find the solution for my question: How do I create a report that covers this month and the previous month ? I have a date field [Ontv_datum] in the table from where I extract the data. I don't want input boxes "from date" - "to date" Thanks for...

Hi, I got a Date field[Provdate-ontv] which only is allowed to set if another field, a Yes/No field[Prov-ontv] is set to Yes (default is no) How do I do that ??

Hi, I'm trying to build a mdb which holds customer details, which insurance they have, who sold them this and which Insurance company provided this. The relations I have to make are driving me nuts ! When I try to enter a new customer in a Form, there is a advisor added, the package the customer...

Hi, I am wondering if and how others create their own help file ? What are the possible methods? I have a manual but now it's a separate document. I would like to stuff it 'inside' the mdb file so it's always available and easier to maintain. Hans

Hi, I've been reading some posts about late binding to prevent having errors with different Office versions. I have this issue.. However, I don't know how to implement it in my own code.. :-( Anyone willing to help me with this ?? Private Sub Exportmail_Click() ' Private Sub...

Hi, I want to block editing certain fields after a date (+ 7 days) This date exist on the form in the txtDatumFix field Now I have this: If Forms![Inschrijving].[txtDatumFix] < Now() Then Me.AllowEdits = False Me.AllowAdditions = False End If I want 7 days on top of the existing date...

Hi all, I'do a Transfertext to a commadelimited csv file. Decimal values that are exported in this file, are rounded to two decimals and have a comma i.e. Original value : 81,2222222 Value in csv : 81,22 Value needed for import in Mysql : 81.2222222 Is it possible to change this with VBA code...

Hi all, I've got a downloaded (through php) file with xls extension, but in fact it's not a real xls file. When I open manually (in Excel) and click 'Save as' it's offering to save as a textfile. When I save it as xls, the file grows in size and then I can run VBA code on it which edit some...

Hi, I'm importing four colums form an Excel sheet into a table. One of the columns has dates in it in this format :d-m-yyyy u:mm This Ecxel file is a download from an MySQl db. The props of the table date field are default date/time. It 's no option to change this, because the MS db is used by...

Hi all, I use an Excel import to update tabel 'deelnemer'. This works oke BUT when user 'x' has a linked field in tabel 'B' the import fails due to RI (I think..) How can I make it so in this code that the user record is updated and can I restore the RI (otherwise my forms won't work..) This is...