Search results

Ok, I have a form (unbound) that I have written my own load and save methods for. On one of the subforms (there are about 5) there is a combo box that is populated with a select query. I save the ID from the combo box into the database, but I am having trouble getting the combo box to then load...

Well, today I had a problem with my main access db. It stopped letting me create MDE files, and my usual trick of decompiling it didn't work. I eventually got it working by importing everything into a blank database and setting the startup form and references again. However when I did this, I...

Well, I got asked to do this with a datasheet view today, and I found after searching the forum that I'm not sure how to do it, and no one else seems to have done this either. Basically I need to flag a row in a datasheet subform dependant on if a date field is more than 1 month ago and if the...

Ok, I'm setting up a new frontend for my DB, as it needs to give some different forms etc to a different person using it. I want to link a couple of the tables that are needed, and I get the message 'blah can't open the file. It is either located outside your local intranet or on an...

Well, I have a problem that I can solve by hand, but I really wouldn't want to. I want to move my form calculation out of my form timer and into the AfterUpdate events of all my controls. Unfortunately, the number of controls is roughly speaking, huge, and spread across about 8 different...

Well, the title is fairly self explanatory :) Basically, the DB i am working on has a set of calculations that are performed every 0.5s to keep values updated. There is no need for this to occur while access is minimised, and a couple of users are complaining that their computer slows down at...

Hi all. I'm currently stuck trying to find a way to set a printer to print to file from code in VBA access. Any help would be appreciated (I need to do so to get a non adobe pdf printer to work in code). I'd post code that I have, but the only code relates to the pdf printer so far, and not to...

Might be the wrong place for this, but can anyone help me with this. I have a textbox with a large font sixe(72) that i want to have at the very top of the page. The contents are entirely lowercase, and i want them aligned to the top of the textbox. Can anyone tell me if this is possible, and...

ok, ive been looking and looking every where for this, and cant find it :( what can i put in a string that will tell a textbox to put it on a newline? i.e. Dim line as String line = "such and such <want a new line character here and so on>" so that it would output as: such and such and so...

Im having trouble getting an SQL update to work. It keeps on saying 'Syntax error in UPDATE statement'. I cant seem to see anything wrong with my code, so i think i need someone else to see it. heres the code thats not working conn.BeginTrans Dim Sql As String Sql =...

Is there a form function in VBA that i can put code that will mean it is run every time something is changed in the controls on the form or will i need to put the function call in on the afterupdate(or similar) function for each control on the form?

Ok. here is the problem. Im creating an interface for access, and I would like to create an array to store forms in. This is so I can use the array with an integer as a stack. This will then let me use the stack to store the order that forms were opened in so I can then undo them in order as the...