Search results

Help any one I cannot for some reason create a data link file for a Visual Basic project I am trying to write. When I write click the data link folder to create a new data link I do not get in my pop up menu the New Microsoft Data Link option. Any one know why?

I think I could use those VB links I took a look at the tutorial link and I think it would help me but it was a weekly thing and the stuff I need to know like today The tutorial goes over in almost a month from now??? go figure thanks for all your help.

I am satisfied with the Access applications but I am a contract Access developer and a new one at that and in a meeting with the client I was explaining how to maintain the databases that I created and he explained that he wanted these to be maintance free??? Well without thinking I told him...

I am trying to convert several Access applications that I have written in Access using VBA to executeable VB programs I seem to be running into some problems executing the docmd. in Visual Basic if I understand correctly the Docmd is not valid in Visual Basic 6.0 Well how can I if I can import...

I seem to be having trouble with the carriage space character in Visual basic editor for Access. I can't seem to get it to appear in the editor.

I know that you can import into access a text file what about an ASKI file? If so How? Thanks for all the help you guys are great. John

I am having a problem using the select all command on the edit menu I write in VBA Docmd.DomenuItem acformbar, aceditmenu, 7,,acmenuver70 but I cant seem to make the select all step an automated step any body can help thanks

I am having another ole issue I ca open powerpoint in Access as an object ican create a new presentation and i can create a new slide I can even edit the text in the slide but how do i put a chart in th thing please help i check postings often and i check my email daily...

I am just beginning to learn about OLE automation and I need something cleared up how much control can you contain in Word through access using OLE Automation For example can I create a graph in word and print that graph? or could I open an exsisting file in word then delete the contents of that...

Have you tried to enter an event action in the after update event of the result text box on your form This may be an option to pursue after update make the value of the text box avariable then make your table an openrecordset and user the edit update commands to add the variable to the...

your vb code should look like this: Dim myvariable as date (actually declare variable in appropriate form ie String Number and so on) Dim myrs as recordset Dim mydb as database set mydb = currentdb set myrs = mydb.openrecordst("name of table") myrs.movefirst myvariable = [myrs]![Order_Date]...

I had the same problem and the reference was deselected access is weird that way

Wow that's really interesting I am also at a lack for a solution but if I were you I would troubleshoot this problem by recreating your query in the "front end" query builder in access. Then you could view the query in sql and use this for research Please let me know what happens and how you...

Have you tried to set the validation rule on your tables maybe something like >=0 would work this would force some one to input either a zero or some positive real number into the field that contains this rule You can set validation rules for a table in the tables design view you can also set...

Maybe you could define a variable as public in a module put that on a form that you would keep open the entire run time and assign it a value on the same form that will always be open and use that assigned variable for the recordsets name at all the points where your user would edit the...

Yes that's right code does come from the macro. I have looked through the Access developers hand book and this reference suggests creating and running code that is written by you, the developer because you can trap and test errors, which I feel is a duty of any IT professional nothing to me is...

Thanks again for all the good advice. On the same subject I have what may seem to be a stupid question but I will ask anyway. If you create an application and run all your queries in VBA in Access 2000 and then create another application and run all your queries through macros will the...

Thanks the RunSql is the ticket I knew it was a simple command that I was looking for.

I seen to be having a problem with executing a query on the click event of a button on a form. I am not sure what method to use and how to use it I dont think I want to use the docmd.openquery because I want this query to execute within this module the sql for this query looks like this...

Any help would be greatly appericated. I am getting the error 3051 when I try to execute the transfer text action with the do command. The error reads: "The Microsoft Jet Database engine cannot open the file ". It is already opened exclusively by another user, or you need permission to view its...