Search results

I dont know if this is possible but I want to change a yes/no field from a list box. I can load data in fine I can even loop through it to see what value each item is but, is it possible to allow a user to change a value from a list box? If not do I have to use the Datasheet view?

:banghead: Not sure whats going on here, nothing on the table that stops this from working. I just get Run-time error "2448 You can't assign a value to this object" When the code runs. Any ideas what I am doing wrong? Private Sub Form_Open(Cancel As Integer) Dim rst As DAO.Recordset MySQL = "...

How would I update all SQL stored within all forms to change its syntax? I am returning all the row-sources for all the comboboxes on all forms in an Access db. Most work fine but some have syntax errors, for example double quotes instead of single. Is there any way of finding these stored...

I want to create a table of all fields in a form, their datatype and their controlsource. I have done the first 2 parts easily enough using the forms.formname.controls.name property and TypeName(forms.formname.controls) But I am unable to pragmatically read the controlSource. EG...

I think I have a table of 6-bit ASCII, a sample message looks like this: 13M@F0@000wN7GPPWesdWRin05kd How do I convert this to standard ASCII? Thanks Rich

In Excel there is the web query. How would I do the same thing in Access VBA to bring in data from a web XML table?

Hi want to move a file onto a server and need to provide the user name and password within the VBA. How would I do this?

In EXCEL I bring in a large volume of data in recordsets. All the dates are in mm/dd/yyyy format is there anywhere to specify when setting up the recordset the date format as dd/mm/yyyy?

I have a VERY simple query that looks something like this: select a.id, b.id from table1 a, table2 b where a.id = b.id; Now table1 has 3 records with the same ID and table2 has three records with the same ID. I expected to get 3 records returned. I actually get 9. This query has worked...

I have been trying to do this for ages and couldn't find it online. Well here it is: string = the file you want to launch. Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL string"

I have 1 user who is constantly getting poor performance from my front end, combo boxes hanging and complete crashes. On investigation it looks like all my recordsets will not close on his machine. I am using the below code to close all of my recordsets at the correct time and searched the...

Bit of a two sided question this, 1) How can I specify where in a table I want to insert a column, I would like the ID column at the begining, but this code always appends to the end: DoCmd.RunSQL "ALTER TABLE OS_MAINb ADD COLUMN [ID2] BYTE" 2) Now I am sure this is a simple one, how do you...

I am running the below using a function that sets up the recordset and connects to a database. I know this bit works as I use it all through the DB. The only differance in the below is that it is a more complex query envooving left joins. Can I use a left join like this in a recordset...

Hi using access 97 how do I programmatically export a table in DBF format? You can do this by right clicking the table and exporting but I can not find the function in VB. Thanks

Hi I have got my emails working fine and I can add an atachment from a drive, but how do I add a query or a report as an attachment? Using teh sendobject function its simple but i cant quite get it to work with CDDO. Dim cdoConfig Dim msgOne Dim colAttachFiles() As String Set cdoConfig =...

I have a field that I want always be stored in Upper case so use the Ucase$ function: Forms![CyclicJobInput].JobName = UCase$(Forms![CyclicJobInput].JobName) It works fine on an XP machine but on a Win2K machine it errors saying it cant find the function. Although I can see it in the VB object...

I have done this hundreds of times before but this bit of code just will not work, I am sure its a simple problem but i cant see it. Please help! I am getting a value prompt box when I click OpenQuerys. Private Sub OpenQuerys_Click() Dim v_MONTH As String Dim stLinkCriteria As...

Hi, I am trying to import any spreadsheet that is in a given folder in this case C:\temp\CI. I can only seem to import 1 at a time how do a loop? and how do I make the table name the same as the XLS file it is importing? Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport...

I had a look at the search results and I couldnt see what I needed. I want to import spreadsheets and create the tables using the files names of the XLS. This is what I have so far anyone able to help? Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97...

I have a bit of code that uses a froms JobNumber (which is an autonumber from a table) and uses it to append some informatin to the same table. My question is, when does the autonumber shown in a form appear in the table. If I use my code as it is now when it pick ups the jobnumbe it is not yet...