Search results

thanks i will try that tomorrow

My query alredy does the search and has one record with one field in it to determine the last number - that bit works fine. What I'm trying to do is to get that number out of the query

I have "total" query that finds the last number in a table and it has just one field in the table - so when I create anew record i want to look up the last no then add one and then create a new record. The code works in onw query but not in another - - - any ideas guys? Dim stDocName As...

I'm doing a number of queries to get the number of records that meet the criteria in a certain table. However if the number is zero then i get Null and the code bums out. Any idea how to make the null as zero?

Not the most elegant programming I know - but I'm opening forms to get data then closing using VB code. Is there a way to stop the screen showing these forms as the code runs something like Display refresh off then display refresh on. Just to hide my workings from the masses

Thanks guys - yesterday I could not get it working so went back to our overnight back up and lost the work done. Today the same error has come up again. I don't want to loose the last few hours work. how do I do a "system restore" I cant find it in the menus

I'm designing a form and when I tried to open it i got the error message "you cancelled the previous operation" now i cant open it in design mode to fix the error. nothing happens any ideas?:banghead:

I have a number of stores and when I create a new part number I want to email a notification, but only for certain stores not for the rest and be able to edit the list easily code like:- if ([StoreCode]=1 or [StoreCode]=3 or [StoreCode]=7 or [StoreCode]=9 or [StoreCode]=11 or [StoreCode]=12 or...

I don't want to do different thing depending on the value just to do one thing based upon if the condition is one of a list of possible options

I want to do an "if then" statement in my code, but to see if it matches a list something list :- if A= 1 or 2 or 7 or 9 then but this syntax is wrong so i need something like if A= 1,2,7,9 then is there a slick way to do this?:confused:

Thanks Minty - does anyone else have any help here ???

I'm trying to print a barcode to be used for data input into another system. The data contains alpha number and some special characters like space, underscore, / and & I want the form to print the bar code Any idea cus 128 and 3of9 don't handle this data.

How do i do a compile?? Yeah I tried adding the base query again to the upper query using show tables and it showed the original fields only. I saved the original query and reopened it and the new fields appeared Ok :banghead::banghead::banghead:

Heres an odd thing:- I have a query based on a query when i added a new field to the base query, this field did not appear in the list of fields in the design definition when i try and add to the upper query. (Hope that made sense) it just shows the original fields only. Same thing happened...

i just love learning experiances ;)

thanks - do you know the syntax

I know how to send a report in access 2003 via email - but how do i just send an email without a report??

I've got a piece of code that I use in multiple places in my database. Is it possible to store it somewhere once and call/link to it from the various places? it uses variables set from the form and from tables/queries.

During the import i found the error. the table Msyscompacterror was a table linked to another database - the table didnt exist in this other database. So I deleted the link and the compact worked fine :D

Fantastic - never knew about that options - will try now. I was trying a "push" rather than a "pull" :eek: