Search results

Are Grabart, Friedhof and Kategorie numbers or text? If they are numbers that should work, but if they are text i think you need some extra ' s. It took me ages (and a lot of help from these forums) to get the hang of these, so i know how you feel! If they are text then try this: Set Gebuehr...

Hi. I have a form which shows a record with all the meeting notes that have been made about it in various meetings. I set it up with a before update event so that when something was added to a note the meeting number and item number populated automatically (Meeting number as max meeting number...

Ah, dont worry - searched for it a slightly different way in google and came up with this: Forms.FormName.SubFormName.Form.FieldName Works great.

Hi, I have a form with a subform. When the form opens I have set every field on the subform to be locked (by using the on open comand of the subform). However, I want a button on the main form which a user can press, enter a password and make all the fields on the sub form unlocked (i.e. to...

I would suggest putting in a 'docmd.requery' just before you open the report.

Is the table finding information already stored in the table, or is it just going to store something? Can you explain a bit more?

Hi, Should be a quick question... If you open a form via vba with a where condition and then re-query... eg: DoCmd.OpenForm strFile, , , strCriteria DoCmd.Requery would the requery affect the where condition (i.e. remove it)? I dont think it should, but thought it was worth a...

as in 380Mb. Thanks for all your suggestions. I do have a lot of forms etc so i will try and cut back on them as preciously mentioned. All my data is linked from a backend, so that shouldnt be a problem. I do have a couple of images which are dotted around most of the forms - so i will store...

Hi Dave, thanks for the suggestions. It could be an unsaved record - ill try that. The thing i dont get (and that rules out the other posibilities) is if i try to do it manually (open the form, select the ID record and find a certain ID) it works! Ive checked the strID thats stored, and that...

Just under 380,000KB. Thing is, its only just starting out - theres a lot more to be done, so i thought if i figured out small ways of saving space now then i would be in the habit of doing it later!

Hi. Thanks for your replies. I have all my tables linked at the moment, which is helping keep the size down. I also compact and repair regularly. I have done a quick look like sugested by wazz (Thank you!). Queries are tiny (which i expected) Forms are a lot bigger, and reports bigger still...

Hi, I was just wondering what the main contributor to database size was? E.g. Linked tables, queries, tables, report or vba code? Trying to cut down the size of my db, and this would be very helpful to know!! Thank you!

Hi, I have a bit of code which im having real trouble with. What it basically does is stores some variables, and then uses them to destinguish which form to open and which record to go to. The form opens fine, but then i ask it to find the form which has ID = strID. Im using the following...

Thank you. Ive gone for the query option. Thank you!

Hi! Hopefully quite an easy one, but one that will be a bit of a disaster if i do it wrong! I have a database that is already in use (and therefore has a lot of data in) We are expanding a certain section of it and i need to copy and paste append some data into a table which already has 500+...

Thanks for your suggestions. Fortunatley it was very similar to another ofrm i had, so i deleted and started again. Seems to be fixed now, but ill be sure to look out for any other things like it. Thank you!

I have a form which doesnt want to save!! when i click close it asks me if i want to save, when i say yes the box disapears, but the form remains open. This happens everytime i try and save. If i say no, it closes but doesnt save and i loose my work. Ive done this a few times now, and tried...

wonderfull... cant believe ive just spent about 3 hours looking for missing " & 's!! Thank you!

ah, just saw your 2nd post... I tried select from but it didnt like that, but i forgot about the *, ill give it a go now. Thank you!

the next few lines of code are: strSQL = ("SELECT TblPcrMain WHERE TblPcrMain.ProjectNo = '" & strProj & "' AND TblPcrMain.PcrNo =" & intPcr) Set myDB = CurrentDb() Set myRS = myDB.OpenRecordset(strSQL) so i guess it might be getting the error when it tried to open the recordset?