Search results

Hi All, I am learning ASP.NET so bare with me. I am using Visual Web Developer 2005 express to create a simple dropdownlist that gets its info from an MS Access table my server. It runs fine local, but not when I uploaded it my site. Exactly what do I need to add to the web.config file? Error...

Hi all, Numerious people are interested my a database I created. Can I sell the .MDE or MDB file with out an Access 2003 Developer license? Assuming they have MS Access installed? Thanks

Hi all, I am trying to update a field based on another field through a record set. In this code I want to update SYS if Element_label is like 3 (the field has values 3.1, 3.3.1 etc...). Am I going about this the right way? Dim rst As DAO.Recordset Set rst =...

Hi all, I am trying to update a field based on another field through a record set. In this code I want to update SYS if Element_label is like 3 (the field has values 3.1, 3.3.1 etc...). Am I going about this the right way? Dim rst As DAO.Recordset Set rst =...

Hi All, I've searched the forum and have found a lot of info on locking records/forms. I pulled this from a thread but it doesnt work. I have a subform with many fields with a check box. if the check box is true then I want to lock that record(or the form). I loaded this in the on current event...

Hi, I am trying to list all active users on my DB. I need this so I can tell who is on when I need to edit the db. Currently I log the users in a table. I want to know how to list all the active users. This code only shows me being logged in. Any ideas? Dim user Dim i user = Environ("UserName")...

Hi All, I have been working with Access for a while and I am ready to put my front end on the web. Where do I begin???????? What should I use? Is Mysql the way to go? If so where do I begin? Thanks! Bones

Hi All, I am using a date function that will send an email out on the first of the month. It runs on an "on open" event. My question is how do I get it to run once? Because the way I have it set up now, if the database is opened 20 times on the first of the month, it will send the email out 20...

Hi All, I've searched the forum and I cant seem to find a solution to a simple problem. I am trying to gather a bunch of email addressed into a string, to send out a mass email to all my admins. The code below only emails the last email address in the record. Thanks for the help Dim rst As...

How does one report spaming on this Forum?

Hi All, I am having trouble printing my images on a report. The report is linked to a query. The problem is that its only printing the last image on record. Here is my code. Thanks for the help. Private Sub Report_Activate() Dim pathx As String Dim Loc As String Dim nm As String pathx =...

Hi All, I have a text box (memo field) that the user enters a description. This is sometimes more then one paragraph. In a text box you cant hit enter and goto the next line (or paragraph). I would like to to this? can it be done? Thanks

Hi All, I have a text box (memo field) that the user enters a description. This is sometimes more then one paragraph. In a text box you cant hit enter and goto the next line (or paragraph). I would like to to this? can it be done? Thanks

Hi all, Does anyone know how to Export Yes/No Value to Word Checkbox? This is what I have so far. Dim path As String Dim objWord As Object pathx = CurrentProject.path & "\file.dot" Dim dtnow As String DoCmd.SetWarnings False Set objWord = CreateObject("Word.Application")...

Hi All, Is there an easy way to show that a record has been deleted (besides "audit trail")? for example: if record_id 2 was deleted, the fields can show "deleted" thx

Hi All In reference to my last post: http://www.access-programmers.co.uk/forums/showthread.php?t=102106 In my code below I get the users info from "username = Environ$("username")". My question is, can I use that value in my sql statement? I keep getting an error "No Value Given for one or more...

Hi All, I am trying to learn sequel strings and I have a question. How do i extract the value from this sql statement? Thanks! Dim myconnection As ADODB.Connection Dim myrecordset As New ADODB.Recordset Set myconnection = CurrentProject.Connection myrecordset.ActiveConnection =...

Hi All, I have the following recordset count the number of records, if there are no records I get an error. is there a way around this? (some info: the table "tempMX110" is based on a query "qrytempMX" and sometimes will return no records) ' Count Number of MX-110s DoCmd.OpenQuery...

Hi All, I keep getting this message "too few parameters.Expected 1" when I run the following code. My query has a criteria in one of the fields. When I run the code with out the criteria it works, but it exports ALL the data from the table. Dim rst As DAO.Recordset Dim Path As String Dim...

Hi All, How do update two different tables (fields) from one text box from a form? Thanks