Search results

Pat! Many thanks for yr response on that. I have saved the suggestion for future reference,which I,m sure will arise again. HOWEVER In my deperation I found another way to solve the problem. It may not be "Politically Correct" programming but it works. I added a new column to my...

Thanks Alexandre. Sorry That my posts aren,t really clear Ihave been burning midnight oil on this since Friday and I am starting to confuse myself as well. So here is the problem better explained I hope I have a form called "Ysplash", i n which resides the list box (list46) Listbox displays...

Tks Shay and Alexandre. I am not intentionally running 2 threads..the only reason i reposted this was the other was disapperaing without a response and i felt i wasnt clear enough. Shay ! Date = can be any day of the week,and their can be multiple locations on any given day..(sporting events)...

I have been looking thru the files here for help on doing a requery. From stuff i have found i get the general idea,but in practice i cant make it work. The listbox has the following fields [Date] [location] I can find on the date fine,but I am missing something in trying to get an...

Many apologies for raising this item again. This covers my problem,and I understand the requery concept,my problem is I simply cant physically apply the instructions/ I have 2 field in my combo box: [date] [location] My situation Is My combo box is set up to run Query1,upon double ckick on a...

Oops Sorry folks!! I think I had a complete mental block on this. I have achieved the Update using a straight append query. Thinking logically (In a new day),I guess the quey couldnt update because there was nothing in the receiving table to update.

I have imported some delimited text files into a table. The delimted text has no headers and Access gave each field a name,F1,F2,F3 etc I have a nother table with correct field names,and have written an update query. IT RAN ONCE,and appended about 1/3 of the total items. Since then it refuses...

Tks Rocket. Yep u r right about that. I also got it! The ascii Table I was using as a reference was in fact giving the Oct value of the Ascii code. I tried a new table and used the Dec code and it works fine. How Damn confusing Thanx

I was given some help a while vack by "Raskew",but unfortunately Iam still having a problem with this. I have a column,with single alpha characters in upper and lower case,eg: "W" "w","P" "p" etc. I need to be able to extract data using say just the lower case "w" and change it to a different...

Is it possible to get Access to distinguish between upper and lower case (First alpha),in a query /sort. The relevance being being that the Upper case alpha is of more importance (ranked higher )than the lower case alpha. Thanks

Thanks Pat. Yes! It looks like the only way out is to create a series of queries. Getting the number and sequence right is taking a bit of thought. Thanks

Ok ,so I have identified the prob.,but I dont know how to fix it. I have 2 tables,that r linked by a left to right join on 4 fields. The idea is to pull a value from the second table (that paricular field is not joined). On occasions one or more columns in each table may have a null value in...

Tks folks! Dont worry I appear to have resolved the problem. All best

Can someone tell me what I am am doing wrong. (as u will guess vb is not my strong point but it does work..up till now) My script worked perfectly until I inserted: DoCmd.Run Macro "imtempclwrtm" Into the statement. The script appears to ignore the Run macro command. Heres the bit that doesnt...

Thanx I had tried using null value insertion,but that didnt seem to work. Why I dont know 1 column is the main,and the others are all sorts of sub classes. I have sort of in a long winded way overcome some of the problem,by running about 8 different queries on each variation,and appending them...

I have a query made from 2 tables. 4 of the fields are joined. When I run the query provided all tables have a value/text,the correct answer is given HOWEVER if in any of rows of the joined fields their is no value/text (null) in any 1 or more of the fields,then a zero answer results. Each field...

This is an update to my post under tables which I now have working. The only thing I cant do is trigger (from the Access command button),the macro contained in the xl spreadsheet that i have exported to. I have tried setting it as a module,and referring to that,which opens the module but doesnt...

Thats Interesting! I get the same prob,when i use conditional formatting,to highlight an item on the form. when u switch to the next form it seems to have a prob relocating itself and does a shutdown....with all the probs that causes. Will be interesting to see what resonese u get

I need to be able to query my table for the "Last/Latest Date" on which a product was used. The table has [productname][date]. There is therfore an entry for each date the product was actioned. Just cant seem to get the syntax right in the query criteria to pull the right date.

Many tks. YES!!! u r right I did find it,and it works ok. All i have to do now is figure out how to unhide it But at least iam on the way. Hopefully this solves the final part of my developement