Search results for query: *

hi all, i a report in access 2007 i have 3 fields, field 1 = Price field 2 = discount field 3 = total to get total working i did have =([Price]*20) then the price will be * 20 in total, now the field total must also calculate the discount, in that field there is 0% till 100% how can i...

hi there, strange thing just happend, I have 2 fields: Me.Test & Me.Serienummer both contains the same value! (12345) When i run this code If Me.Serienummer = "gstrNummerserie" Then gstrFactuurnummer = Me.Factuurnummer gstrAanschafdatum = Me.Aanschafdatum gstrGarantietijd = Me.Garantietijd...

Hi there, When a user logins and clicks the login button, there must popup a msgbox that automaticly disapears after 5 second. there must be no buttons on that msgbox it just appears and 5 seconds later is must disappear and continue the rest of the code. is there a way to implement this...

Hi, I want to open a form with a macro, in that form there is a field named: "NaamMedewerker" Stored in a variable "gstrDezeMedewerker" now the form must open on the right record, so the where condition must be something like NaamMedewerker = gstrDezeMedewerker i Tried this...

Hi, i have 3 fields, that must be put into 1 field, so field 1 is: Test Field 2 is: 12 Field 3 is: 3 Field 4 is the field wich contains all information, so when a user puts in data, VBA must automaticly put all 3 fields into 1 so that Field 4 is: "Test 12 3" How can this be done, is thought...

Hi there, I have a table with 3 fields, "Merk","Type","Productnaam" On a form the first combobox is "Productnaam" The seccond is "Type" The third is "Merk" When the first combobox has the value "Windows" then the second "Type" should show "98, 2000, ME, XP, Vista" then when the second is...

Hi there, In my table "tblstatus" i have a field named "Versie" its a Text field. in that field this number is filled in: 211880 In my first form of the database, a field (that is hided) has also a number: "211880" the form must look if this number is the same, higher or lower.... If...

Hi there, I have a update query that is running when a form is closed, then the query asks the user if he is sure to delete ** records, or to edit records. is it possible to disable this message? Greetz

Hi there, When i run my app in Full access the form is normal, when i run my app in Runtime access, the form resizes en the letters just go Big, if a label is named: My App 2.0 in Runtime it will show very big: My App 2. its with all forms, any ideas

im my other post i have problems with Runtime access and alot of VBA code, my database is working correctly in a full version, but not in a runtime version. after alot of research i found the following: on the onopen event: Private Sub Form_Open(Cancel As Integer) ' Niet toegestaan te...

Hi, when all of my users press Aanmelden (login) they get an error that says: execution of this application has stopped due to a run-time error The code behind this button is: 'Check to see if data is entered into the UserName combo box If IsNull(Me.cmdNaamMedewerker) Or...

Hi there, Im trying to calculate the warranty, in a form, (onload event) it must check if the warranty is still on, Datediff must calculate the differce between [aanschafdatum] + 12 Months if the buy date is more then 12 months ago, the checkbox must be False, When its in the 12 months, it...

Hi there, im trying to open another form with a Where condition, "=[Datum=]" & "[Datum]" but instead i get a syntaxis error, somethign like that, Dutch hard to translate.......... am i doing something wrong , the samecode works for another form but that isnt a date...... I hope someone can...

Hi, When i create a form and save it everything goes well, autoresize is working perfect, after a few days and a few modification, the form suddenly goes smaller and you see scrollbars, when i open it in design mode, make a small change and press crtl+z and save it, the form is correctly again...

Hi there, In a form i have 5 comboboxes, they will look into a table for records, lets say it will show 5 records now. under the 5 comboboxes there is a button that opens a form, in this form you can add a new record in the same table as the comboboxes are looking in. but when the record is...

Hi all, I have a form that can be opened in 2 points, 1, all functions must be enabled, 2, some functions must be disabled, and in point 2, i want also to disable the navigationbar from VBA code, is that possible?? Greetz Lightlancer

hi there, i have alot of forms in my database and now they must look into a table (tblstatus) if this form is enabled or disabled for users, i know to put this in the onload or on open event, but what code do i need to use, to let the form look into that table and look for a field and then if...

Hi there, im using a form that opens a word document, but in VBA you must enable something redirection, and then check Office word 12, and then the VBA code works and opens the document, now when i develop the database to run at Runtime access, this doesnt work anymore........ any ideas...

when i click the button, the checkbox goes True, when i close the form and reopen it, the checkbox is False again, it should be True, its like the record in the table is blocked or something but it isnt. am i doing something wrong???

Hey all, I have a table named: tblStatus in that table there is only 1 record with 8 fields in the form there are 2 buttons for each field, named: IN or OUT when i click IN, the checkbox for this field must go "True" When i click OUT, the checkbox for this field must go "False" how can this...