Search results

Hi, I have a form with start date and end date and I'm trying to create a visual for the duration, so I would like to add a box that will change the width according to the duration in each row. I have this, but it does not work, not sure why? Can you help me? Thank you. Private Sub...

So I have a table: table1: company_name, year_month, company_rating, rating_change For each company, I would like to compare the rating from 201201 and 201202 (and keep going for each month) and if there's a change in the rating, update rating_change to the difference in rating values. The...

Hi, So I have two tables, table1: (company_name, company_code, year_month, rating) table2: (company_name, company_code, year_month, asset, debt, equity,...) What I would like to do is to call up all the data in table1, and then call up (asset, debt, equity,...) from table2 where the...

Hi, I want to create touch screen buttons, which the user can use to input numbers, but I'm stuck at the "." for decimals, because I can't enter that as long data type directly So I thinking I can either change the string to long data type or use the text entered to calculate behind the scene...

Hello, I have code that extract attachements from emails in a dedicated folder in outlook from my access fe, after this action, I would like to delete the email, or failing that I would like to move it to a separate folder so that I don't get duplicates. Any pointers? BTW, sort of a generic...

Hi, So I'm trying to update different records, each to different value, each using a different criteria, but I want to do it all in one code. I tried something like this from a hidden form base on the table to be updated: Set myrcdst = Me.Recordset With myrcdst Do Until .EOF...

Hi guys, I have another question I need some help on, how can I transfer a field from one table (or query) to another? So I have a sales table with a field "counter" which keeps count of the sales for each customer (cust A 1,2,3,4, custB 1,2,3,4 and so on). Now I think storing it this way is...

Hey, So I'm trying to set a connection to a separate database with this statement Dim dbs1 As Database Set dbs1 = OpenDatabase("C:\database2.mdb", , False, ";pwd='abc'") An error message keeps popping up saying "not a valid password", but I am 100% positive the password is correct. Is...

Hi, I was trying to convert my database into a .mde, but during the process, there's a warning popping up saying: I know the strange name is the tables, because when I open my property window, some of my tables behind the forms or report is not shown with its name (the one I gave) but with...

So I have a check box and a combo box in my form, and if a user click on the check box, meaning they want an exchange, then I want the combo box to automatically drop its value, which is a list of reasons for the exchange, how do I do that? I feel just putting the focus on the combo box control...

Hi, I'm trying to delete all the files from a folder once I've copied it to another location. Now stuck at trying to find a code to do the deletion. Tried deleteFile function, also object.delete, something like this: dim myObject as object set myObject=me.path 'path contains the...

Here's my situation: I have two work stations which I can't connect by a network, location too far apart, internet's not an option currently, but I want to share the data that's entered at the factory with the users at the office. I'm thinking of extracting the back end copy of my database...

Hi, I have a form with many buttons, one for each room, and when I click on the button, it will open another form, go to a field (roomNumber) and enter the room number in that field. I got the code for the action down, but I'm stuck at how to program all the buttons on the form (the form...

Hey, I have been manually making backups (copy and paste) of my BE database, but would like to have it done automatically for me, does any one have any pointers as to how that can be done? Thanks.

Hi guys, I'm wondering if it's possible to open other programmes from Access? Is it possible to make my access software connect to my scanner and save the newly scanned pictures with the recordID generated in access as its name, or the reverse, have the software retrieve the name the picture...

Hi, I'm new to Access, and I wonder if you wonderful people can explain what are some of the ways I can create users and password for my database. Is there anyway I can prevent people from copying the database from a computer and use it on another computer? And lastly how do I create a front...

Hi, Not sure if this is not a stupid question, but when I try to open two forms with controls that have the same underlying control source, I encounter a message that say "the table is locked and cannot be malnipulated pregrammatically", or "the table you tried to open is being used, please...

Hi, I've created a table that has a date field and many locations field, to show when a location is taken up. In each location field, there's three list box options: empty, sign in, sign out. How can I make it so that when I choose sign in, the record will stay in "sign in" as I go down the...

Hi, I have this problem that's killing me. I have created a splitform that allows me to add items I'm selling, and allow me to see the new records I've just added in a datasheet view just beneath it. Now I need to select these new records that I've just added (the form is in add mode, so it's...