Search results

I have made a big MDB and at some point when I tried to DELETE a form an error message pops up saying that duplicates can not be inserted ?!?! After that if I try do display any vba code the DB says that the module does not exist! What can I do?????? Any help appreciated!!!!!!! THanks

advera just asked .... anyway... On your form use OnOpen event if (tablefield.value + your comparision period) >= now() then code... end if

- indexing the search fiels may improve performance - try to convert date to string. use that for grouping - use built-in functions not yours - if you need merged strings as search field in the another query you may alter the sql and you will need less query's. As modest said ... 'slow' is...

because the sql has finished the job If you don't want to close the query and open it again ... i do not know why... then you have to save the search results into a table, bound the table fields to a form then requery the form or filter each time you changed anything. or you can use the...

or use " & chr(34) & " instead of "

Sorry Is there any "bit" field in SQL db with <null> value? Not 0 or -1 ; True or false! Use the enterprise manager for this! Have you set the default value for the bit to be 0? - this is to avoid errors in the future. Then should work. Try to create a normal update query first and if works...

You may check the followings:

Thanks neileg

Hi, Could anybody tell me if there is a way to use a memory variable as query criteria? If yes then How? But not passing from VBA. Thanks.

opinion I see that you know the answers to all questions but there are others who don't, and actualy they may need help... This is a public forum and is not open only for the good "english speakers". wouldn't be better to keep this kind of idea for yourself?

Thank you Pat! One more: How can I check the table "type" in vb? If is local or linked... Thanks.

Hi guys, Could anyone give me a code to create linked table to SQL server using ODBC Connection string? Thanks.

Try to update the control on the Mainform when the OnCurrent event occurs in the subform; Forms![<MainFormName>]!txtAuditNumber = ME.AuditNumber

If the combo is on the MainForm and the SubForm is on this then under AfterUpdate Event in the MainForm: Forms![<MainFormName>].[<SubFormName>].Form.RecordSource = "A_" & [Unviewedlist] Me.<SubFormName>.Requery

I would use the following syntax: If the ComboBox is on the form where the Event occurs: ME.[ControlName] = value you want to add(ie. field name) else :) Forms![MainForm]!([SubForm].Form*)![ControlName]= value *If subform exist.

I would use the After Update event to change the value of the unbound combo box then update the table/query field and the combo with the ID. I assume that you want to store the ID... With the On Current form event I would populate the unbound controls. You can display in the combo's drop down...

Thanks RAK, I found useful information but because this database will be used outside our network and to save time I would like to replace only the altered form or query. I am thinking on using an FTP to copy the whole DB (I know how to do that) but re-building the changed form or query...

Hi All, I am working on an Access database (2000) which will be used by many users. My question is if is possible to build/create forms and queries using visual basic and storing the source in a table. Thanks.