Search results

I agree. I wouldn't be suspicious, except a lot of them seem to have done exactly zero programming tasks before.

I didn't realize you hadn't done any programming before. This might not be the greatest first task, as it is a little complex. If you decide to forge ahead, you will need to put your code (procedures) in a module. You can run them by calling the procedures from an event, like an on click...

You need to install the office web toolkit (I think it is version 2.0, but not sure). Then in your tools menu you will have an option for web services.

Typically what you would do is use the relevant data from the form in a saved query, and then set the recordsource of the report to the query. Your query could be something like SELECT * FROM WhateverTable WHERE SomeField=" & Forms!YourFormName!YourFormField etc. Is that what you are asking?

Yes, I have several subreports like this and they do work. Check your link child/link master fields, maybe your second instance isn't linked properly?

Did you mean to post this in the excel section?

I think that the official limit is something like 200, but I have never heard of a system that was functional with that many connections. I don't think there is any set answer, it really depends on the system - if everyone is working on one table, that is really going to lower the number of...

you need cancel=true within your if statement. That is what cancels the update.

If you run the query from the query grid, it should ask for the parameters one at a time, that will tell you which fields are not recognized.

Yes, I see your point. This is sort of a tricky scenario then. Why can't they use a bound form? Or, what if you create the new record when the form opens, so that it takes the autonumber at that point, and then on save do an update event to store whatever they entered?

Why not get the next autonumber on save instead of on open?

you can do this in code: Dim tdf As DAO.TableDef Set tdf = Currentdb.TableDefs("YourTableName") tdf.RefreshLink Set tdf = Nothing

yes, just put validation in the beforeupdate event.

ok, refer back to my post #4 - that should get you plenty of examples to work from. If you get stuck, post back with a specific question and someone will try to help you.

Maybe I don't understand your objective, but this seems like an overcomplicated way of doing this. Are you aware of can shrink and nz? For instance, if you want to hide a field that happens to be empty, just make sure that field is set to can shrink = yes in the properties. If you want to a...

I think it is pretty common to put work samples on a web page (get a free blog if you don't have a website), and then list the site address under Other at the end of your resume. Or, wait until they ask you for work samples and then give them the address. I think portfolios/stuff on paper is...

I think thats about the best you can do. Just make sure you have a frequent backup routine.

I haven't seen this particular problem, have you checked to see if there are any new hotfixes out? Also, you could make a test mde with a very simple report and see if that will open on that machine. If it doesn't, then you know something is wrong with the environment. If it does, there is...

I know it can be frustrating when you don't get the answer you are looking for. There is a great sticky on the board that explains techniques for getting help here - you might want to read it. From my perspective, I gave you a reference to a piece of code that does exactly what you said you...

Well, one thing at a time. Do you have the loop set up so that you have each file one at a time? Once you have the file, then you have to figure out the appropriate way to open them. Are they txt files or something else?