Search results

Yep that was the issue... that'll teach me for using Microsoft's example.... How do you mark this thing [SLOVED] like I see in other posts? It's probably right in front of my face, but I don't see it...

Trailing spaces problem [SOLVED] So, I pull some data into a recordset (I call: rsSTART), then I create a table using VBA open it with another recordset (I call: rsBUILD_A) All I am trying to do is use positional logic to fill the data from rsStart into rsBUILD_A. The problem is, when I push...

Does anyone know if there's a way to utilize the "#Error" message that comes up in queries as a result of data type issues? Meaning is there a way to filter on or omit the data that results in a #Error? I have a bunch of string values that denote, what they call, an Assetnum... although it's...

Essentially I am trying to find a way that I can have users send me a table without them being able to fiddle with it. I figure an accde file would work for this endeavor. What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This...

So after I posted this... I tried the stupid thing again and it worked without any issues... Previously I had run this dang thing like 10 times in a row (easily) and it didn't work... I did nothing to change anything and it opened just fine... Apparently just writing to the boards, fixed the...

I have a form that opens when you initially open the MS Access file... This first form posts session and user ID data to a sessions table, then closes itself and opens an end user form (i.e. the main form in the application) It's work just fine for many weeks, up until a few minutes ago. Now...

This thing has gotten to the point where it's starting to drive me nuts. I have set the format of a text box (named: scrILS) to percentage. It shows on the form as 0.00% When I try to run calculations off of it like: = [scrILS]*[totBuysFYDP1], it throws this error: #TYPE! It seems as though...

1st. Why are you doing this in the form unload event? Shouldn't you do the first goal in the onchange event of the first combo box? 2nd... I'd probably make a close button on the form and make that stuff happen on the OnClick event of the form-close button... and put your validation checking...

This can be done... if you just wanted to post the results of the query to two worksheets within a spreadsheet, copy the query twice, name one whatever you want to call the first worksheet and name the second query whatever you want to call the second worksheet... then run this...

I wrote a quick & dirty simple recordset example... I added a "users" column/field to the Project table and fill it using the code. Take a look at the OnClick event procedures of the "RUN CODE" button. HTH, Gary

So you just want user 1, 2, 3, to cycle against all projects so (e.g. project 17 would = User2?) Is this what you want?

I used that log error function just recently... Just click that link and copy that log error function (below) cut it and paste it under your main function, so it can be referenced, then you should be good to go. HTH, -Gary

Not sure what your macro does, but if it dosen't create table [tbl] and you've dropped table [tbl] There's no table [tbl] object for this line: DoCmd.RunSQL ("insert into [asli] select * from [tbl];")

Thanks I'll try that... With what I am doing, it takes a lot longer to delete the data from the table and append the new data to the table than to just copy over the table with the new data. I am pulling in data from oracle, using a passthrough query, I then use a make-table query based on...

What I want to do is run an action query (i.e. make table query) using VBA from an OnClick event procedure to overwrite a table. The kicker is, the button I am clicking is on a form that is bound to the table I am trying to overwrite. Is there any way to disengage the form's bound table...

If the queries are exactly the same... UNION them together. This will give you the values in both queries... You can do this by: First make two almost identical queries (one that gives you the Premium Data as you want to see it and the other that gives you all the standard data. Make sure both...

Yes, if you want to only get data based on some MAX field, you first have to make the aggregated query and group by your ID field. I am not certain, from your post exactly what you need. I am making some assumptions as to your [Complaint Summary].[Case Reference] field. If that value is...

Honestly I am not sure from your description what your trying to do with that code, specifically. It looks like you're trying to breakdown the code without considering any of the variables in the original VBA (e.g. Test, Product, Date1, Date2 etc...). Consider using a passthrough query to...

There are definitely pluses and minuses with everything. One benefit of a make table is that it's a one object solution, that takes less VBA to code for and less work to implement. As far as bloating goes... if you're copying and compacting your Db file on a regular basis, that shouldn't be...

Sorry I didn't see this sooner, but you can push a "make table" to your back end database file, from the front end...and it's super easy to do. When you choose to create the make table query, you will be prompted for a table name. Below the table name prompt, you have two (radio button)...