Search results

Splitting the table is a must, in order to get my end result. I said I did this from the getgo. But why must I split it is the question. I pulled this from the internet: MS Access allows up to 255 columns in any given table that's a lot!. The table I am pulling in only has 170. Now, I am...

Do you have to have a function to do this? Why not create a query def? That way there's an object you can refer to after you've set your query. (optional) Create a query and give it a name... Then do something like this: Dim strQuery as String DoCmd.SetWarnings False Set qrySearch =...

Sorry one quick but important error in my post... It's telling me record is too large when I try to combine the table and file too large when I try to run the process for the entire table... Getting to the responses: Normalized or not the tables are what they are. These are Oracle tables used...

I thought I posted this last night, but I can't find it even searching on myself... so I guess in never took... if you actually see this elswhere on the site, my apologies... I am attempting to create a metrics analysis table from another table. What I would like to do is copy the structure...

No sure... is it opening either query, or just doing nothing, when you click? I'm not sure if a string value of "Yes" is the issue, it might not be recognized as a string... Yes/No could be true false... you could try either: If Me.dropdownname Then DoCmd.OpenQuery ("QUERY1") Else...

I could never figure out how to get the delete query to do anything worthwhile, but then again I am not as smart as most of these folks... I am sure they'd be better able to help... The way I'd do it is a bit messy, but it should do the trick unless your form uses "Table B" as its source...

Yeah, so basically you have to have a column to your table... maybe call it: [Job level]. Once you add that caolumn to your table, you will then have to go through and tag each person with a designation (e.g. "Team Leader" or "Assistant 1", "Assistant 2" etc... etc..) Once you have everyone...

Something Like this... Column1: Mid([YourField], 1, 5) Column2: IIF(Len([YourField]) > 5, Mid([YourField], 6, Len([YourField])-5), "")

Keep your tables, but cut your query down to the minimum amount of fields you ABSOLUTELY NEED to display. Try strating with just your camera and just two other fields. Then use "group by" i.e. click the sigma symbol (it looks like this: Σ Totals). See if that doesn't get you closer to what...

In design view of the form, goto the OnClick event procedure in the properties of your dropdown box. In there you can add code something like this: IF Me.dropdownboxname = "Yes" Then docmd.OpenQuery("Query1") ELSE docmd.OpenQuery("Query2") END IF That will run two seperate...

Hmm... seems jumbled up doing it like that... could you just concatenate a date string to the time string your created... and then convert the whole thing into a date... using the CDate() function? For example: use the date function (i.e. Date()) and the value you created and concatenate...

Seems to be you're putting quotes around both your numbers making them text values... is Access giving you a type mismatch? Lets say your number was 23, and your subject was books your strSQL: strSql = "SELECT '" & Me.number & "' ,Karin.[subject] " & "From Karin " & "WHERE '" & Me.number & "'"...

When Exporting an MS Access query to Excel (via. docmd.transferSpreadsheet...), the Headers of the query will convert the Pound "#" symbol into a period "." (I'm using Access 2007, if it matters). Before people start telling me that it's not good to use special characters in field headings...

I had a quick question: When I click on the design mode of a query object, generally MS Access defaults to the GUI design view... but in this one application, the design view is pulling up queries in SQL mode first... If I want to set it to the GUI design mode, I have to either hit design...

Actually what happened is (unbeknownst to me) there were several possible Child/subforms that all look the exact same, which can be actived, based upon the choices one makes in the Parent/Main Form. The button in question is location on the subform. So when I pulled up the main Form in design...

So I have this Application that was made by another devloper. There's a button on a form with an On Click event attached to it. The only issue is when I put a break point ANYWHERE in the code... then go back and click the button. It doesn't break. Additionally, some code runs, because the...

I understand there are other ways around this... but I had a question about the manual process of enabling content. I'd like to have a processes that ckicks off when the files is opened... but this is impossible in our environment, because all users must first chose to enable the content of the...

DNA but beware

I am getting a new laptop at work. The old Laptop has MS Access 2007 and the new Laptop has a 64 bit version of MS Access 2010. I have copied many of my MS Access files over (i.e. accdb files). The issue is that I cannot seem to open any of them. Every time I do I get an error message saying...

I know you didn't mention processing time at all... and maybe you don't need to speed things up. If not, ignore this posts. However, if things are running slowly for you, you might look into passthrough queries as they can often run MUCH faster than ODBC linked tables. Especially since you seem...