Search results

hello, i'm having a problem with setting up a query that only needs to show data from one table that's not in the other one. I'll explain a little: I have 2 tables (i've got more but this are the ones i need for this query) called tblUsr and tblGameUsr In tblUsr i have 2 column called 'Id'...

Hello, I have a problem when i want to insert a string into a table using SQL Insert Into statement example: set db = currentdb() set rs = db.openrecordset(AnSQLstr, dbopensnapshot,dbfailonerror) rs .... .... 'examplefield: RS!afield has this string = "an example that has an ' inside" when i...

Hi, I'm working with an Informix 3.32 32 BIT dbserver and want to connect my pass trough queries dsnless by setting the .connect parameter in the querydefs. here's my odbc connection method (with pass-trough queries). I have one table in my Mdb file with the diffrent connect type's (to...

hello, i've searched this forum for a sollustion but didn't find any. Here's my problem and some info about the actions: 1 - I have a continuous subfrm called 'FrmHfdPersUit' that has 2 buttons 'nieuw' (on subfrmheader) and 'bewerk' (in cont.form) and some textboxes which can not be selected...

hi, I'm making a new Mailmerge with the bookmark function in VB access first, I'd like to know how i can add a 'Bullet style' (like '-' or even better, a real black-bullet, in front of each line) in word trough VB. I'need this for a correct layout, if a text is bigger than one line it goes...

hello, I'm trying to make a function that gets every itemdata in a listbox (checked and unchecked) to make word docs. I fill up the listbox (6columns) with data from other textboxes (ex columns: Type,dotplace,name,adress,state,...). The data in this listbox gets deleted after each document had...

Hi, I'm trying to move all my files (4008 files/1 dir) to move to different dirs. i've made a function out of some examples on this board. But without success. here's my code, i hope someone find the fault. Public Function Movingdir() Dim objdir As Object, objfiles As Object, objfile As...

hi, i'm trying to make an errmodule so i can see in a table when a user makes a fault other then 0. i have this as err in each function: Call ErrorDB(me.caption) and a module: Public Function ErrorDB(errctl As String) Dim db As Database Dim LSQL As String Dim errnum As String Dim errdesc As...

i just saw something strange. I've made a recordset that checks if the settings in the settingtbl are correct, if not it has to say which settings are incorrect and the value that is in it at the moment. (make string) when the msgbox shows up and there are more then ten incorrect settings it...

hi, why won't this sql string work in VBA, i tried everything and it seems to be something small, but i don't see the fault :( What i try to do is a check if a record already exists with the RefNumber and the companyname. as you can see is RUit a string and Mednam a number. this code is placed...

hello, I'm trying to make a vba script to check if a user has access. i have a table called Vaststellers where the username is stored in the first column "gebruiker" and a second as Yes/No box if the user is marked as active. there is more data in this table but for the moment i only need those...

Hi, I'm searching a VB function where i can do the following in my form: I have a form with 3 checkboxes. Each checkbox has a memofield hidden underneath it if the checkbox(KZ_onvol_geg) = true then the memofield (example: Onvoldoende_gegevens) must be visible. When the checkbox is false it...

Hello, Is it possible to not use the intern mailmerge function. What i try to get is the following: When i press a button on a form it has to export the data from access (only that form) to word (with an *.dot file) But i don't want to use the bookmark function in word. what i try to do is...