Search results

i didn't fix it but i created a make-table query with this field and then an update query it's something about the SQL server that doesn't like some of the stuff that access lets me get away with. this is a second issue like this: something that worked with an access BE and doesn't work with an...

first of all, i apologize, i converted my db to sql server and keep having problems so i've already posted and will keep posting more questions. IIf(Not IsNull([SVCSETSSERVICEITEMS].[RefFIeld]), IIf(Not IsNull([RefFIeld]),[RefText]) & DLookUp([RefFIeld],'QFilesServices','ID=' &...

no, he messed up this year))))))))))) you mean i should make it 2 field high? nah, i tried it before with other dbs amd never liked it. it's ok, i'm already doing it, just complaining in the process))))))))) i'm shrinking the combo to the width of the arrow so the space is not the main issue...

my issue is not the OTHER part. it's a few things first of all, my form is continuous, so i can't have fields that are hidden and unhidden - it can either be hidden or unhidden for all rows, not hidden for some and unhidden for others. second of all, i'm running out of space (from left to...

thank you. that's what i'm doing as i'm talking to you guys. i came here hoping that i'm missing something and that i won't have to have it this way. there's a few downsides to it (for my purposes). and also, this database is huge, i was hoping to launch it on tuesday and this is a major...

hey, the reply right below speakers' was for you, i forgot to quote you))))

for some reason you keep making me lol with your replies. i'm not sure what's funny but i thought i'd share))))))))))) ok, it's not that easy, if i remake it - then it will stop doing what i wanted it to do. i'll be back to my problem of having a combo that should accept free text and not...

here's the RowSource of the combobox SELECT SVCSETSSERVICES.Service, SVCSETSSERVICES.ID FROM SVCSETSSERVICES WHERE (((SVCSETSSERVICES.ShowFile)=-1)) ORDER BY IIf([SortNo] Is Null,"NULL",[SortNo]); and here's the RecordSource of the form SELECT CLIENTFILESERVICES.*, SVCSETSSERVICES.Service...

i thought it should as well and was shocked when it didn't))))) i don't have a relationship set up, if i go in the table itself and type the numbers - it takes everything fine. read my setup above, i described exactly what's on the form. is it making more sense now? omg, as i was typing this i...

i'm sorry, i'm not good at explaining things, i know that about myself, just bear with me please. there's a table 'SVCSERVICESETS' that has ID which is an autonumber and SERVICE which is text. there's another table FILESERVICES that has a SERVICE field which is a number. on the form the...

this was an interesting idea)))))))))))))))) i went and tried but Access didn't like it, set it back to YES and that's what i WAS doing with the access backend and it worked. once i switched to the sql server it stopped, here's the message "Cannot add record(s); primary key of table...

I can't when the bound column is hidden, it auto sets to YES

yeah, that's my worse case scenario: using 2 fields. that's what i will do if i don't get any suggestions. i'm just making sure that there's not something there that i don't know before i do. thank you))))))))))

i did already. i'm probably not explaining this right. hiding the fields is not a problem. my main problem is how to let the combobox accept any entry but NOT show them in the dropdown choices.

Hi, i have this problem that if the hugest pain for the past few months. i finally got it to work, finished the project, migrated to the sql server and now it's not working. i'm assuming it's because the sql server has stricter rules??? anyhow, i need a combobox that's based on an id but...

never mind, i'm an idiot, everything works, thank you

i think they're just explaining how to create an account for the sql server. or am i missing something on that page? i already have an account that has access to the SQL server. and i didn't understand, what do you put instead of the TRUSTED CONNECTION line?

hi, so i'm now up to this point. i set up a file DSN on the server and it works fine on one computer but when i try to open the database on another - it doesn't. here's my File DSN [ODBC] DRIVER=SQL Server UID=natalie DATABASE=MY DATABASE NAME WSID=COMPUTER NAME DSN WAS SETUP ON APP=Microsoft®...

Got it, no, that's not my case, I need them in the tabke or a query so I can export it. And thank you for the luck, most of it will come from AWF))))))))

You meant using a report to get the numbers and then do whatever I need? How? Just wondering. Also, soon after I posted I did it by using a few make table queries. And you do help me a lot so thank you very much for that.))))))))))))) And I will be back with more problems soon: finishing...