Search results

KirRoyale if you open your query in design view and look at the ribbon at the top you will see a parameter button. Click on it and remove any entires there. That is why it's prompting you. Also for no decimal places you might be able to get away with using the Clng function on your field which...

Ok well maybe modifying may not have been the right choice of words but what I am getting at is you have the data open in two places at once in the same db. Your form and in your code correct?

Is your form accessing the same dataset you are modifying?

Yes that sounds right. Going to investigate. As to try and answer your question here is the all the code in the simple query reference form where users click on which query they want to see and opens in read only. Private Sub Form_Load() Dim db As Database, qdf As QueryDef Set db =...

Taking a step back almost seems to fix everything :D I think I'm going to use that as a signature line :P Glad you got it working.

No worries it's all good :D

Haha I'm glad I stumbled on this post today I needed the laugh! (I don't mean this in a bad way) You guy's are great and this forum wouldn't be much without all of you. So just putting out a big thanks to everyone that has posted here trying to help others understand. A little off topic but...

You could simply create a single table in the remote database that has one yes/no field (being boolean) and toggle it on or off to tell the remote database to do something eg (close or do something else). Just make sure the remote database has a timer that runs on a short time and inside the...

CJ I had thought about using a form but the employee's like using queries because they can take any of the data and copy and paste what they want into excel to do other comparisons or charts with thus the reason why I designed a slew of what I call Reference queries that open in a read only mode...

Hello all, It's been a while and hope everyone is doing ok. I have a question and it's maybe more on a basic level but when I open a query that has results with more than 200K records when I click on the date field it takes a while before it gives me the selection of the dates to filter with...

Sorry a little to busy to research the appropriate solution to help you finish what you want right now and if anyone can chime in and help that would be great otherwise I will get you the answer tomorrow or much later tonight if I get the time. Good Luck

If you use the function called datediff it should give you your difference in whatever format that you want.

By using DAO in the database you will need to change a few sections of your code but start with changing Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset To Dim db as database, rs as dao.recordset That will get you started but your going to need to change your...

Couldn't you do something like the following? Dim AccApp As Access.Application, AccFrm As Access.Form Set AccApp = New Access.Application accapp.OpenCurrentDatabase -db link- Set AccFrm = AccApp.Forms("Whatever the frm name is") ' Then do something with it

Your not giving much info here to support your code. Are the variables Finish and Worked part of a class file or are they Types and why not just store the value's in a table so you can have your report get the data from there?

Use the web. Post a video on Youtube, research and find a good free webhost or get a low cost one like hostgator.com and make a website for your company, post blogs about your experiances, list your website in the search engines (Google, MSN, etc...), make a facebook channel/site and invite...

Ow trust me I'm never afraid to ask but it's a huge slap in the face sometimes when looking back because that should have been the first thing I considered. Anyway for time metrics I'm almost embarrased to say but here we go. 1st Meathod: Using .FindFirst Processor stays at 50% due to a dual...

Because I was being retarded :/ Holy crap sometime's I'm a big idiot. I get sucked in to programming mode and never think of using a query for this.... Thanks spikepl and please forgive my stupid question

Hello all, This is something I seem to battle with a lot is what is the fastest most feasable way to modify remote data (meaning a front end trying to modify backend data). I have created many projects and have been able to mitigate most of them but this one is eluding me. Any help is...

You mentioned this: "In item 1, 2100 will found one item in field "FE" which is in item 4" But when looking at the database the only field that has item 4 in it is "NE 2G". Was the example wrong that you typed or is the data in the database sample incorrect?