Search results

Well it turns out it was my fault that they weren't showing up, and now I've worked out why; I have the criteria set to "*" so that it will only show records which have data in this field... turns out that the records I was looking for didn't have data in this field

OK so i've pretty much gutted the DB to exclude any sensitive information, so you should be able to see what I've done with the query and form. Have a little look through the query and hopefully you'll see what I'm trying to get at. I've removed a lot of the information that I referred to...

No no the calculated values aren't stored; I've been warned of this elsewhere so I haven't done it. I have sums on my form which are calculated depending on the selections made, so they are constantly changing and thus storing the calcs wouldn't be beneficial. Ok thanks for the update guys...

Earlier in my form I was having problems with a sum. The outcomes from this sum were dependent on a material chosen, so what I did was make 2 seperate text boxes, each having different responses in them depending on the material chosen. Then I set their default visibility to false and made them...

Yeah I figured I could get away with less code if I used the update. I'm going to create 2 queries and run the relative one through a simple If statement in the OnClick event. I'm not going to run into any snags with this am I? Also, how can I populate a text field with another text field's...

I had a think and an update query would be quite fitting. What're the down/upsides to using an update query instead of using code? Thanks for the links, I'm seeing what I can do with them :)

Does it require complicated coding to appoint the update to the required record? My coding knowledge is limited... improving, but still limited. My data is coming from a number of textboxes using information that is calculated from various sums and I'm not sure how to get this all to link into...

Sorry, I used add losely; I meant it in the sense that I would like to add data to an already existing record, hence the .Edit After looking at it I realise that there's nothing in my code saying what in particular I'm looking to edit, which is the reason it's just editing the first record in...

I have an add form which is supposed to take the info input into a form and then add it to an existing table. Here is the code that I've used: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tbl06ButamerAllLines", dbOpenDynaset, dbSeeChanges) With rs .Edit rs!UniqueID = Me.txtID...

That looks good. Can I use the dates in my textboxes as a superficial array? Or do I need to formally organize it? I also don't understand all of the code but I've seen similar sequences elsewhere. With this section "var = Array(#1/1/1980#, #12/31/2010#, #7/7/2011#, #7/7/2012#)" have you just...

Well it's not quite true about the tables.. I've actually created far too many, but in this form that I'm spending so much time on, I'm doing a lot of it using code (not complex code, just If-Elses's as they seem to be working fine). In a previous form I have a number of combos which are...

The database is to categorise various lines on the refinery I work at. The idea is to run a series of questions on the line in question and the answers output an action to be done. There are 4 different categories that can have actions on (insulation, tracing, metallurgy transition and material)...

To be honest I haven't really used relationships and have tried to avoid them by using code and not creating too many tables.. I'm guessing it's the wrong way to go about it but I don't understand relationships and things so I've tried to stick with what works for me. I was trying to go for...

Turns out I was being a fool and my dates are still working...

With the date that's closest to the current date, i want that to be displayed as the time when an action needs to be put out. Basically, there're 4 possible actions, each one is assigned a date and the date which comes around first will be the most important time. This sounds like i'm going...

I'm trying to get 4 date values from 4 different combo boxes into a table so that I can then run another query to select which of these dates is closest to the current date. In another post somebody mentioned looping but I don't know how to do this. Any suggestions?

Can I use a query to make a table that will display values from text boxes on a form? I understand how to make the table so that each value will be displayed in a seperate column, but can I get 4 different text boxes to be displayed in different rows (in the same column)?

I've been tryin for the past hour and a half to do that and because of the work I've done earlier, it's making it incredibly difficult to do what seems like a simple task. Earlier in my DB I couldn't work out how to do coding in one text box, so I instead created 2 text boxes with seperate...

I don't understand this "abstraction in code" so could you explain what you mean please? And it doesn't always happen at the same interval, hence why I'm getting it to run through 3 different statements to question which one fits it. Can you not explain your previous code for the loop or do I...

Sorry, this only shows one of the sets of answers for one of the boxes; there are another 7 sets of these. I don't want the loop to look at the code though, just the answer that the code produces. Could I do a similar job with If's using the max/min function?