Search results

stra is defined as a string... ill change that to integer and change the field "Name", see if that works! Thanks again for all your help... I shall keep you updated!

Thanks for all your replies. DCrake - We were getting a syntax error before and i read somewhere names with spaces can be fixed by putting []'s, so i went a bit crazy and put them everywhere!! KenHigg - Nope, same problem im afraid. GalaxiomAtHome - This didnt fix it either im afraid. Its like...

Hi. I have set up some code to do a Dlookup. The code doesnt throw up an error, but it doesnt find the lookup. However, when you put the exact same code in a query and run it with the same example it works! Any ideas why this might be happening? The code is as below: stra = Nz(DLookup("[ID...

Ahhhh, Thank you DCrake. And here was me thinking it was some fancy access lingo!!!

AhHa! I may have mis-informed you all... "Table3" was actually a query. I just changed that to a make table query, and linked the table instead of the query and it works fine now. Thank you all for your suggestions though, always interesting to see how other people go about the same thing!!

Nice idea, but i need all of them visible for comparison.

Hi Rich, Thanks for the suggestion. I would need the subform against each record in the continuous form though. The footer would just go at the bottom of all of them, would it not?

Endre - Right, I tried the DLookUp, and it sort of worked... The problem is is that all the records on the continuous form show the value for the 1st record... but if you click on another of the records they all change to that value. Any idea how to make it look at that record (I thought the me...

Ooh, no the new field doesnt need to be updateable. I hadnt thought of dlookup. Ill have a go tomorrow and let you know if it works - i would think it will though! Thank you!

Hi, Im not sure how well I can explain this, so please ask questions if im not making myself clear! I have a form which shows various status' for a every record in a table. It is a continuous form. I need the status to be updatable. I set this up and it works fine, running from a query...

Yes, it works great. It was a silly mistake on my part - as usual! Thanks!

Thanks boblarson, worked great. Much better than my way!

I have a continuous form. In the form header I have put a combo box. I want the combo box result to filter which records are shown in the continuous part of the form. So far i have: Me.ComboDisp.SetFocus DoCmd.RunCommand acCmdFilterBySelection but its saying "The command or action...

Brilliant, thank you. That pulled up a simple error i was missing before! (wrong object being called) Ive never done that debug thing before, so thanks!

Coppied the code into a query and it worked fine! Can anyone think of another way to do it? or why it might not be working?

Hi, I need some code that opens a form on a particular record, then changes one of the fields. I have this so far: strLink = "[ProjectNo]= '" & Me![ProjectNo] & "' And [EmpNo]= " & Me![EmpNo] & " And [Rev] = " & Me![Rev] & " And [Discipline]= '" & Me.Discipline & "'" CurrentDb.Execute...

Thanks, From that I think what im looking for is TransferSpreadsheet... What im basically trying to do is this: I have a excel sheet which is regularly updated. I need to update a table in my Db from this excel sheet. At the moment im copy & pasting the fields in, but i thought if there was an...

Help just gives me a huge list of Ac... showing the possible constants and their values...

Hi. I have a table which stores ole objects (excel, work, pdf, e-mails) Is there anyway that i can get certain objects in the table to output. Almost like a report? I had a quick go, but for objects that had more than 1 page it only gave me the 1st one. Any ideas?