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 seem to have found a way around this problem by creating a host of queries, one for each subreport. The reports are linked by a child and master field to the relevant record in the parent report (so they only display the data for that record as there are multiple records for the same days in...

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...

You're right, it was 1! I messed up in the code there- had messageboxes popping up to show me the values but I'd put them in the wrong part of the iteration loop which explains the confusion. It's working just fine now. Thank you :)

Fantastic, seems to be doing the trick! Thanks. It's just raised another small issue though: when using this method to change the selection in a listbox, it does update the listbox.value but not for the first item in the list. For example: an iteration loop that is used to find a record in the...

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...

Thanks mate, I might give it a go but as it turns out I've dumped the data into a table generated temporarily with SQL when the form is loaded. It actually seems easier to link the different lists to the table and then requery them when neccessary plus I can't quite get my head around the use of...

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...

It would be as simple as changing char to text??! I'll give it a go. This will save me using a hell of a lot of Trim() functions later on.... :D cheers. I definitely don't need fixed width text fields, but I do have to use VBA because the table name must be dynamic and unique to the user who is...

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...

They aren't, it has to be the table because if I enter data manually the same thing happens. I copy the data to another table because I only want to display the data that matches the search criteria (several fields a user can enter data into before clicking "search") The sub uses SQL with the...

Yeah I tried: rs("Account Name") = RTrim(rs("Account Name")) But it hasn't done anything. I think I've figured out why; the table I'm editing data on seems to fill all the remaining space in field length in with blank spaces itself. So the code works, but is simply being "spaced out" again...

I've thought about using it but it poses the following issues: - Ability to detect when a space is legitimate and when it is not. - Potentially slow search times if a lot of results need trimming. I guess the slow search times won't be a problem unless thousands of results are being returned...

Sorry to nag, has anyone got any suggestions? I've been searching for information and I'm working to an increasingly tight deadline here, heheh... any help appreciated!!!

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...

Haha, that works a treat! Ok thanks :)

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...

Fantastic thanks, I shall give these a go :D