Search results

I would use the table structure doc_man has posted, with one exception. the sibling table only needs to be a field in the student table that points to the ID of another student that is the first students 'sibling'. This is a self-reference, or a field in a table that refers to the unique...

You could automatically refresh the data by user the on_timer event, but you might not want to do this unless you check to make sure someone is not in the middle of editing a record (see Dirty property). I would probably rather use the After_Update - so that whenever someone makes the eidts...

I am pretty sure (99%) that you need to do an Export of your report (most likely you would want a "snapshot" file. Then you can attach that snapshot file as your email attachment. I'm not sure what version of Access you are running, or what capabilities may have changed, but it has been a...

Here's my 2 cents worth. If you have fields that are specific to a certain type of policy (ie. income replacement), then I would seperate those fields into their own table. This could get complicated depending on how many different types of policies there are that will need unique fields...

My bad, you're absolutely correct. However, this begs the question, what happens when someone new needs to access the database, do they just copy it from someone elses machine? I guess again that assumes there is a core FE file located on the server, and any development changes that are...

you mention this database running for years, makes me wonder if you are reaching some of the limits/capcity for MS Access. How big is the actual MDB file getting that is getting corrupted? Are you performing regular compact/repairs? (you shouldn't have to run many compact/repairs if the only...

Bob, I'm surprised you suggest making a table with one field, which I'm assuming will only have a single record in it, rather than creating a user defined property... However, I don't believe either of these would work - if I am assuming correctly multiple users will be opening the same MDB...

You should be able to put the lines of code in the code box right where your existing docmd.Openreport is at. however, you will want to write a bit of code in the On Open event of the report that takes the OpenArgs and places them into either a) your controls directly or b) into some variables...

I re-read your original post and now realize you need to reference these dates not only in the recordsource (filter/clause) but for report header info. Are you comfortable enough with string manipulations? Pulling the left half of an arguement and the right half into 2 seperate variables? If...

If you post the code you found (with any modifications you may have made) I'm sure we can come up with something - it may be as simple as saving this report out to the Windows temp directory - which I have code I am currently using, that will do this. But I won't know if this helps unless I see...

Correct me if I am misunderstanding - usually breaking down what you want done specifically is better than "how do you do ....", because like you said an "old dog" might be trying to figure out the procedure to accomplish a task, when what we need to determine is what is the "business need"...

Have you set the Format property of the control to Short Date? Also, you can try make the values into Dates rather than Text strings. StrEndDate = Nz(Forms("FrmStockLevelDates")!txtEndDate, "#12/31/2010#") StrBegDate = Nz(Forms("FrmStockLevelDates")!txtBegDate, "#01/01/2006#")

yobi, Are you wanting to display dates - changing them from the US vers of MM/DD/YYYY to DD/MM/YYYY? Or is it more complicated than that? If you provide more details then someone here should be able to come up with something. Do you have any budgeting to spend a couple hundred dollars? I...

It sounds like you are saying this is happening with one particular MDB, but I don't want to assume so, can you confirm if this is happening on all or some or just one? Also, how big is the actual MDB file that this is happening to? How many objects are there?

What are you doing with the values in your variables? If you are taking them out of the CSV and importing them into an Access table then you can do that directly without the added variables. rsTable("FieldName") = objXsheet.Cells(xRows, CoL#).Value FYI, a "with" just lets you reference an...

yes, it is misplaced. you need to have the worksheet open in the Excel/App reference before you can fill the objSheet with the activeworksheet. Place the most recent line of code I gave you after objExcel.Workbooks.Open FileName:=strCSVPath

missing line of code Now that I re-looked at the code, I found that - at least for the coding that you have posted, which I'm going to assum is mostly complete, it is not setting the objXSheet variable Set objXsheet = objExcel.Worksheets(1) I am not sure, since this has always worked for me...

I might be misunderstanding the problem here, but since you are trying to open a CSV and save as XLS, I am wondering if the problem you are experience with "Object variable not set" might be because your worksheet has nothing in it? I might think it has to do with your opening a CSV and not a...

I might be mistaken, but it sounds to me like you are automatically generating these dates based on the current date. Either way (if the user choses dates or if they are auto-generated) you should be able to based your report source on a query that picks up those dates, by-passing the need to...

I don't see any reference to any controls. Also, I'm a bit confused - is your Switchboard form a sub-form? If so, just out of curiousity, what do you have as the main form?