Search results for query: *

Every time I try to type a space in the code builder, my cursor jumps back a space. WTH is going on?!? PenelopeC ~~~>-/O~~~~~swimming right along

I have this form for data entry regarding projects. On the form I have an unbound list box that shows all records for tblPROJECTS. When the user clicks a project, the corresponding data is filled in on the rest of the form (all of those fields ARE bound.) I also have a subform that shows...

Can someone please take a look at this and help me? I have a form frmPROJECT with an unbound list box containing a string from a query. When I click on the command button to enter data for a new project, I want the unbound list box contents to go into a control called "txtPROJ_IDAdd" on the...

I found FAQ 700-184 and I think its awesome, (thank you MichaelRed) however I'm not sure what to do with it. I saved it as a module and if I run the module on its own, it works fine (so I've got all the changes pertaining to my database correct -- right?) I'm having a lot of trouble getting it...

OMG, I can't even believe I volunteered for this -- I hope you guys are patient :D I haven't built any ASP pages since '99-'00, I remember little pieces and I'm raring to go -- BUT, I can't even save a project to the server it needs to be on. I have the "ASPNET" user with permissions on the...

I have a DTS package that runs a monthly accounting function pulling data from a Progress database. The package has always done what it should until today. I try to right-click/open "DESIGN PACKAGE" and EM gives me the message that the "System cannot find the file specified" If I look in my...

I have a database that is not normalized (its a conversion I did from an old FoxPro db) I have a list like this... fld1 fld2 fld3 fld4 fld5 25 ORSTPOL ORST 25 ORSTPOL ORSTP 25 ORSTPOL ORSTPL Information in fields one and two are repeated...

Hi, An Access97 app was written to parse a BTrieve db and import it into SQL every night. I did not create the application it was a now-long-gone consultant. He did a VERY nice job, but its time for the Btrieve to go. I'm trying to keep the app pretty much the same, just accessing the same data...

Hi All, I have an Access97 application working with linked SQL Server 2000 data. In Access I have a table where the currency field is padded with zeros so it can go into a mainframe. To create a report based on the table, the currency field that's originally text is converted to a double...

Hi All, hoping you can help. I have an incident database where we keep track of system issues that result in a tech having to be called in during off hours (which is interestingly know as a "callout" not a "callin"). The database is very simple, one table with all the info...

Hi, I'm running Access97 on a Win2K Pro box. I am trying to run a query in Access97 that retrieves the first three numbers of a field -- data format=text -- as a grouping level for a report based on the query. This worked before but I've recently had to f disk my hard drive and re-install...

Hi, I had an evil run-in between Access97 and Access2000. I've un-installed Access2000, re-installed Access97 but now Access97 refuses to acknowledge that it should import/export .csv or .txt files. I've already checked that all the Data Access components have been installed, I've done every...

Hi. Please (PLEASE) tell me what I'm doing wrong here... <begin code> Private Sub cmdPrtCallDetailPerAU_Click() On Error GoTo Err_cmdPrtCellDetailPerAU_Click Dim stDocName As String Dim db As Database Dim rs As Recordset Dim i As Integer Set db = CurrentDb Set rs =...

Hi, First I'm gonna say THANKS because I know you all have helped me through some sticky wickets and you probably will again. I'm importing a file of call detail records. I've manually imported the file numerous times, have finally come up with a Spec that consistently works except for one...

Hi I have a phone number field that may or may not have a country code (two digits). I want to limit the size of the phone number on the report to 10 digits - most calls are NOT to foreign countries. So I'm trying to return the right 10 most numbers to give me the phone number. For the...

Hi Everyone, I'm admin-ing an Access97 app that uses modules a lot. I've been pretty proficient at keeping it up (it was all created before I was hired) but I need help with the error trapping bit. I'm having a hard time grasping the whys, hows and whereofs. And I can't get the debugging tools...

Hi, So far, I find PROGRESS to be the most frustrating, obtuse database program ever! But then again I haven't been around that much [ponytails] I'm trying to group by LEFT(a.company_name,3), sp.qty, p.name Progress doesn't like my syntax, however its not cooperating in giving me any idea...

Hi! I've got a spreadsheet like this... Extn Name Price Plan Usage XXX xxx $0.0 14 $0.0 22 $0.0 18 How do I copy down the Extn and Name to fill in where there are rows of data. With the spreadsheet like this, I can't sort and...

Hi, I have one workbook with a master list of phone numbers and the charges incurred last month. In the second workbook I have a subset of phone numbers with NO charges associated, however their cost center is in another column. I'm looking for last month's charges to be added to this subset...

Hello, I've been lurking through FAQs and threads for two weeks and can't find an exact fix for my issue. I have a stored procedure in SQL 2K that uses the Merant OBDC (3.51?) connection to suck data from PROGRESS (9.1C) on a Win2K Server. The procedure will work when run manually from within...