Search results

Hi all, Can someone help me out with this code? Keep getting a type mismatch error in the function convert at the line "digit = Asc(temp(I)) > 47 And Asc(temp(I)) < 58" Maybe ik keep overlooking something, dont know. Thx in advance strBar = "702000000036000063053309999000500" valid = False...

Hi, I have a query in access with several fields made with the query builder. I want all fields to have criteria so users can filter out only those that they want to see. But it needs to be only showing what was selected (in listboxes) as criteria or show all records when no criteria is...

Been trying to figure this one out. I have a form with a subform. The subform is a datasheet and i want to set the column width for the columns in the datasheet. When i put these in the subform upon loading, i get an error when i open the main form. Here's my code...

Once again in need of help. I have a db with articles linked to the articles of a supplier. 1 of our articles can come from more then one supplier. So to make up my order, i choose the supplier and our article number and want to look it up in the db holding the supplier articles. eg.: our...

Have searched for a while, but could not find an answer. Probably is very simple. I have a DB with orders, in order to create an ordernumber i count the orders made this year, get a result and want that result to be 3 digits (eg counted 3 should be "003") Here is my code, but wont get what i...

I keep having a 3131 syntaxis error in FROM. Anyone any idea what i am doing wrong? Private Sub Knop6_Click() 'Variaben voor het lezen uit de database creëren Dim db As DAO.Database Dim rs As DAO.Recordset 'Variabelen waar de gegevens uit de useriddatabase worden in opgeslagen creëren Dim...

Hi, Been chewing my gums on this one for a few days. Have a report which has a query as a record source. Pending on the choices made in several listboxes it spits out results from that group. Now, only when my cursor is in the listbox and i open the query and then the report by clicking on it...

Ok, been puzzled by this one. I have a form with a subform in it. The subform is based on a query. It shows all my active staff. On the form i have a button that (atleast i would like that it does that) when clicked it sets the field "selected" on true on the subform. The code behind the button...

Hi, I have a query with two table's in them. One is filled, the other is still empty. Both table's are related to each other with the field "document number". This was working fine in access 2000, now in 2003 it returns zero results. I am starting to think it is because one table is empty it...

Hi guys, ..and girls ;) i have a calendar that works like a charm, but i would like to add the possibility to add recurrent events in it. for instance if a user has to perform a task at a choosen time schedule, it is shown in the agenda, like each week or each two weeks or each month. Anybody...

Hi guys, this worked under access 2000, but not anymore under 2003 "strtrans" is not getting the value. I can't find what's wrong, tried string, defininf them in a module. Nothing. Anybody any idea why that is? Here's the code: Dim strTable As Variant Dim strField As Variant Dim...

Ok, tried realy allot, anybody can help find what is wrong with this code? [Klantnummer] is a listbox on my form with all the customer numbers in it. in my table it is saved as text. Thanks Private Sub Klantnummer_Change() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As...

Hi, it worked in acces 2000, and now am using acces 2003. Anybody any clue why the string strVoorstel would not get the value? It just returns nothing. here's the code: Dim strVoorstel As String Dim lngTel As Long Dim strQer As String Dim strDa As String Dim lngNum As Long strDa =...

Hi, I have a table with training records. Each attendee is listed with date and the related document he was trained on. Now i want to make a listbox where the user can choose between the different dates of the trainings. Now when several people where trained on the same day, i get some dates...

Hi, This one is a pain in the but. I tried everything, but why would it just won't work. It always says the query is to complex. Have included the database, anyone a solution? Thanks

Hi guys, maybe this has been asked someowhere before or it's a realu dumb one. But can't find it out. I have a listbox that brings up a record in a form. It contains brand, type, kind and serial number. It gets it from my table. When i look at the table, brand, type, ...etc are all filled with...

getting results from queries and populate text labels Ok, i have tried and searched but could not find a good start to a solution for my problem. I have a calendar form, which shows the dates and under it text labels. Now whenever something is present in my table (tblKalender) on those dates, i...

Hi, I have been thinking about this since two day and tried everything, but no luck. I have a form with recordsource a query. A listbox contains all references and if you choose a reference, everything else on the same form gets updated. Now i want to avoid that two users edit the same record...

Ok, am stuck on this one. I have a form with all the navigation keys and it also lists your own name which you logged in with. Value comes from a string called strUser. Now i have made a query (based on tblUsers) that returns me the user that is logged in and his status and acces rights...

Hi guys, i want to send an email to several people when someone else enters a complaint in my database. I have a form which displays the complaint with a reference number, recordsource is "tblKlachten". i have query that is set to return only those emails i want it to send to called...