Search results

I'm using a Query Wizard. It lets me select a table, but when I click on "Next" button, it gives me that error message as if my table has fields that are only memo and OLE, but that is not the case. I searched everywhere I could think. I didn't find anything that specific. It's as if some...

I get a very strange error when trying to create a find duplicates query. When i try to select a table that has duplicate values it brings up a message box and it says that i must pick a table that has at least one field that's not a memo or OLE data type. I look at my table and I have niether...

since i'm in a query, i figured out that i don't need the actual table name, just the field name: LastName: Left([name],InStr([name],",")-1) - this worked great to get the last name. FirstName: Right([name],InStr([name],",")+2) - this didn't work at all...:confused: it's not giving me any data...

I have a name field in this format: smith, john Is there a way to split this into 2 separate fields in a query? I looked up the split function, but it's saying that this function doesn't exist. I also thought this might work, but it doesn't. SELECT left(name,instr(name,",")-1) as LastName...

Thanks! I will try both of these as I need something to get this process complete a little faster.

i'm just wondering if anyone knows of a way to re-format an excel file. i have a file with a bunch of data on it with different columns. then i have a certain layout that this excel file must be in before i can use it. let's say i have original file as follows: column a - age column b - name...

that made sence, thank you. i tried it and it got me out of the method or data object not found error, but now it's producing "Object Required" error. this is what i used: TabCtl.Pages("PageA").SetFocus What am I doing wrong?

i guess you are right, i'm trying to change from one tab to another. i tried what you suggested, but again, it's saying the same thing Methor or Data Memeber not found i'm guess it's because i'm in subformA, trying to update something and then trying to perform that line of code on after-update...

this does work for On-Open event on my main form to set focus to that tab. i need to update something to tabA in subformA and i was trying to do that setfocus event on after-update on subformA and setfocus to tabB. when i do that it produces an error saying Methor or Data Memeber not found for...

i have a form with 2 tabs and a sub form on each of those tabs. form1, subformA, subformB on tab control - tabctrl - pageA, pageB. how can i set focus from one tab to another without actually clicking the tab? i tried this: TabCtl.Pages("page2").SetFocus it's comming up with an error - "object...

thank you very much for your reply. i never thought of doing what you had in there, so thank you. i will try and work with what you gave me. i just need slight changes, i think. i need it to keep all sub fucntional areas depending on what is clicked on functional areas, e.i. if business and...

OK. I'm attaching example database. I have a form in there frmActivateFA&SubFA that has 2 tabs on it: FA & SubFA. I want to be able to go through and activate certain FA, and then when you click on SubFA tab, I want it to narrow down the list from all SubFA to just the ones that relate to...

i don't know if it's really a cascading combo box, i want it more to be like cascading forms or subforms, if there is such a thing. i don't have any drop downs. i started out with 2 subforms, one for Functional Areas were I can click on Active checkbox listing out all Functional Areas and 2nd...

I have 3 tables: tblFunctionalArea FAID, FAName, Active(y/n) tblSubFunctionalArea SubFAID, SubFAname, Active(y/n) tblLinkFAwithSubFA FAID, SubFAID What I need is all possible Functional Areas listed on a form where you can click on active checkbox to activate that Functional Area. Then on...

you pointed me in the right direction, so i put it in my sSQL condition statement and used ORDER BY before doing the databind statement. thank you! really appreciate your suggestion.

I can't figure out how to sort a field in Ascending order. this is what i have: <asp:TemplateField> <HeaderTemplate> <b><u>Live Date</u></b> </HeaderTemplate> <ItemTemplate>...

I think I need to clarify this. I have a DCount() statement on my form for on-click event for a button. If DCount("ProjectStaffID", "qryAvailableDatesCheck", "(((((Forms!frmProjectStaff!Start1 < qryStart1) And (Forms!frmProjectStaff!End1 < qryEnd1)) Or ((Forms!frmProjectStaff!Start1 > qryEnd1)...

I had 2 tables in regular MS Access originally. Eventually everything got moved to a SQL server and both of the tables now reside on the sql server. I had a pretty tricky DCount() statement on one of my forms for a click button event: If DCount("ProjectStaffID", "qryAvailableDatesCheck"...

I have a report and I want to put a field on that report that a user enters into a prompt. Is there a way to do that at all? I want to prompt a user to enter a field and then put the value of the entered field into a report. Thanks.

I will try one and the othe and see which one works best for me! Thank you very, very much for your suggestions.