Search results

thx it works, i didn't use this 'cause i thought it would have worked only with a table..but it works even with query! thx again

i think i've found the problem.. the query is not loaded, so the outputTo cannot find it.. is there a possibility to run the query without showing the preview (or datasheet, or pivot chart, ...) ?? ..i mean something "hide"..

Hi, i've a menubar with a "direct link" to an outputTo macro (exporting a query to an excel file)..in the "admin" mode is working..but in user mode when i click on it i've this message my db is not read only (or i think so..where can i find this?) and is not unconverted from an earlier...

Hi, i've a problem there's a database in a shared folder (two pc connected NOT in a LAN). the database is on the pc called "A", i'm in the other (called "B") ; i open the db and i've a message "read only". so i cannot enter, modify, ... how can i give to the pc "B" the possibilty to modifiy the...

problem solved i've justs unchecked the one that was missing (the "excel11" library) that actually i'm not using and now it works!

.. visual basic indicates this part of the code when the "missing library" message appears If Right$(List0.RowSource, 5) = " Asc;" Then

Hi, i've developed a program in access 2003, but now i'm on access 2000 and seems that one / more library is/are missing.. i've this part of code Private Sub List0_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim strOrd As String, strSql As String If Button...

EMP thx very much!! it works! and thx to raskew, very useful website!!

Hi, i want to create a booking system but i've a problem i've these tables cars _ car_id _ car_name booking _ book_id _ book_start _ book_end _ car_id_fk and the following data: car 1: booked from 11.01.2007 until 14.01.2007 car 1: booked from 19.01.2007 until 24.01.2007 car 2...

the query is not needed... i use almost the same code of the non-multiple..except for the column (was like this "[CLI_ID] = " & Me.List0 only, now is "[CLI_ID] = " & Me.List0.Column(0) ..the "problem" is that i'm not sure why and how it works..:D:D :D

i've made something like this ..it works,but isn't properly with the multiselect code.. Private Sub List0_DblClick(Cancel As Integer) DoCmd.OpenForm "cliente", , q_lettere_inserzioni_internet, "[CLI_ID] = " & Me.List0.Column(0), , acDialog Me.List0.Requery End Sub where List0 is the list...

yes, it's possible, but you've to pass the id through a code..because, as pbaldy said, a multiselect always returnes null..so no id

honestly i've no idea where to get that code..can you help me please?

thx but after doubleclicking on a field i've a runtime error3075 ..it cant' get the value..i'll search something here as you 've suggested

Hi, i was wondering if it's possible in a listbox with the multiselect option set to extended simply click on a field and open a form with the data of this field.. example: i've a listbox of my customers, (only first and last name)..i click on one of this and a new form with all the details'll...

thx a lot! it works

mh, i'm not sure i get it.. now i've something like this Private Sub List2_DblClick(Cancel As Integer) DoCmd.OpenForm "inserimento_cliente", , , "[CLI_ID] = " & Me.List2, , acWindowNormal End Sub i've to put Me.List2.Requery after that? i've already tried but isn't working. I mean..it works...

Hi, I've a listbox. Once i doubleclick on a data on this listbox an editing form will open. I modify my data, save, close. But the data on the listbox are the same as before.. how can i update this data?? Something like once i saved & closed the editing form the listbox will update....don't...

hi! I've a question.. I've a form with two fields (min and max). How can I copy those two fields in another form and generate a list of values that are between min and max?? the two form and the data are not linked with tables.. FORM A -------- min = 3 max = 15 FORM B -------- 3 4 ... 15...