Search results

I understand that I can use an append query to add data to a table from a form and then have it run by using a command button. I want to do this because when I link the form directly to the table I do not want the form to create a new record every time it is invoked. (it does this automatically...

I would like to create a calendar report but I am having some issues; I cannot change the captions of the labels within the subreports (I have subreports representing each day in a month) as visual basic says "object does not support this property or method". Basically I planned to manually...

Hi there, If you have a listbox on a form with a series of items in it, either as a value list or from a table/query, how would you go about using visual basic to automatically select (highlight/"click upon") an item in that listbox? I have a command button on another form which must take the...

Hi there, Is there a way to change the currently selected item in a list on a form using Visual Basic? I need to be able to change the currently highlighted item in a list (move it up or down, or select a specific item) but i can't find the syntax! For example I was playing with things like...

Hi there, I've been trying to copy the contents of a listbox containing a value list from one list to another. There seem to be techniques on the internet for moving data between lists using recordsets but I don't see how to apply that when using a value list instead of a table/query as a...

Could anyone suggest a reason why writing an SQL command "create table" in visual basic would successfully create a table *but* change the way the data is stored in the fields? For example, if I created a table with one field: strSQL = "CREATE TABLE whatever ([MyField] char(20));" DoCmd.RunSQL...

Hello there, I'm having a problem very much like the one described by this user where an SQL statement I am using to read data from one table and copy it to another is filling the remaining field space with blanks. I didn't notice until a VBA module I worked on later on which was to read data...

Hello there... AGAIN. I want to change the active tab in a tab control in a form using VB. I've tried: form_formname.tabcontrol.pages(2).setfocus in this example I was trying to select the second tab of the two in the control. I decided that I need tab controls to cut down on the number of...

Hi there, I have a simple bit of VBcode in my database which reads the password a user enters and 'encrypts' it for storing in the user table. It's more obfuscation than encryption to be honest, and I feel limited by the 'text' data type assigned to the password field. At the moment it works by...

Hello there! This might not be the right section to post in but it's regarding tables. Basically I have some SQL statements that copy data to a new table, which is written in VBcode and operates on the click of a button. Basically the only problem is the messages: "You are about to paste # rows...

Hey there! I've been searching about this forum and found a lot of threads on this sort of issue but haven't been able to figure it out from those alone, so feeling a bit useless :o long winded explanation by the way... I'm useless at explaining! :D Well basically I have a query that is...

Hello there, I'm trying to call a subroutine in one form from a sub in another, and passing it a simple integer in the process. Bit of a newb at this, if it was a sub from the same form then I could just write the name of the subroutine and it would be quite happy... i.e.: [random code] subname...