Microsoft Access / VBA Forum

Anyone knows how to convert .CAP files to .TXT files ? because Access doesn't read .CAP files, so in order to import it, i'd have to manually open all the .CAP files and "save as" filename.txt before importing them onto Access. is there a way to automate this process? Thanks,

I'm using strFileName = "\\serverName\folderName\fileName.txt" If Dir(strFileName) > "" Then ... This worked fine for me, even when I disconnected from the network, but when a user ran it on an unconnected laptop the Dir line threw an Error 52: Bad file name or number. It seems like Dir should just return an empty string instead of an...

I have form showing instructions and logging actions and I would like the form to show a count down timer for a certain period of time. E.g. 30 secs, going down to 0 and then displaying the action. I want the user to be able to see the seconds counting down. Can anyone help me? thanks

One of the calculated controls on my form often divides by 0 thus giving the #Num! error in the control. Is there a way I can write my calculation to avoid this, i.e. display 0 if this occurs? I tried using =IIf(IsError(Calculation),0,Calculation) but no dice. (The calculation/IIf statement is the Control Source for the control, not done...

Here's my code in query design (column FIELD) Date of Birt: IIf(IsNull(); IIf(IsNull(); ); IIf(IsNull(); ; & ", " & )) The result is "Alabama, 2/12/2000"

I'm using a tabControl on one of the forms of my MS Access database. The grey bar looks pretty bad on my form. Is there any way to change the colour of the tabs or the tab background for the tabControl in MS Access? I'd even resort to an API call if necessary. Thanks! P.s. Anyone else having problems posting to the Microsoft news server?

I created a database program in Access and used Auto Number for the ID field. While testing the program I populated the fields with info. Now I want to have the ID numbers restart from zero. Can this be done?

Hi all. Hopefully a simple one for any SQL guru. In an Access query, how can I group by a date field, without having my data broken down by time? In other words, I just want a count per day, not per second or whatever. I'm using Access 2003, but I doubt it matters in this case. At present I am just using a function (see below) to strip...

Hi there, I've not used Select Case statements, and as MS Access help is as much use as a chocolate teapot I thought I'd post my query here. I have a combo box showing Task Summaries. When a particular one is selected I want Access to create a message box that a new tab is visible. I can create the msgbox and show the tab, but how do I...

Hi, Is it possible to fire a "Truncate <table>" from VBA (access2003) into SQL server ? Special considerations ? Thanks

Hi, I am trying to write query expression that finds the position of the first number in a string. So, this recordset... DUS2345.4 D2789.6 .... would return the following positons

I'm trying to do something that I'm not exactly sure how to go about. I know about queries and how to do those, but my form isn't set up for that particular purpose. Like a webpage that has a "Check Username Available" type of function for some, that's exactly what I want to do. All my form consists of right now is a text box, txtUsername, and a...

Hi There, I'm a beginer in Access and VB. In my Database, I've got a form with a subform. the subform is a query from a table different than the table of the main form. those tables don't have a link yet. the main form is being use to create a new entry/ a new row in the table. What I want to do is use the primery key from the main form...

I’m trying to use DoCmd.TransferText, (I use it successfully with a .txt export every day) to export a table into a CSV file. Right now every time I try – it says: Run-time error 3011 The MS Access db engine could not find the object ‘Inventory#scv’. Make sure the object exists and that you spell its name and the path name correctly. I...

Hi all, I was wondering if any of you guys can help me out with this: I have two fields on a form: one field is Premium and the other is Brokerage. Whatever amount is in the Premium field is multiplied by 10% in the Brokerage field. If I change the amount in the Premium field, the Brokerage amount should change accordingly as well. I know...

Hi all, Very new to this forum. Searched for relative postings but found none. Question: Does anyone know of any application that could convert/import scanned docs (PDFs) into access database (specified fields)? I constantly deal with paper works from clients like purchase orders, etc. and data entry into access is very time-consuming...

I have a need to convert simple dates (i.e. 02/14/2005) to a number, do some math, and convert back to a date. (in a simple query). The math involves adding or substracting days, and days of the week . I've used the weekday() function to convert dates to numberic days of the week (1-7) I've used cdbl (date) to convert a date to a serial...

I need to be able to enter an elapsed time into a text field. This time then needs to be converted into seconds and stored in a field in some table. The user will enter a time (format is h:minutes:seconds) as such: 0:15:34 (0 hours, 15 minutes, 34 seconds -> 934 seconds total) or as another example:

I have a query written in MS Access that has a few calculated fields. Is it possible to refer to that query in a form field. I'd like the form field to show the sum of one of the columns from the query I've written. I've tried to put the following in the form field's control source property but I'm getting an error. Query1 is the name of...

Hello all: I was wondering if anyone has tried (and got to work) calling a c#.net ..dll from VBA code? I have been working on this for about 2 weeks and am not getting any where. The_King

Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis

Is there an easy way to make all negative values positive in a particular table? I've been experimenting with this: Dim rst As DAO.Recordset Set rst = db.OpenRecordset("tblNegValues") Do If rst!Amount < 0 Then rst!Amount = rst!Amount - (rst!Amount * 2)

Trying to help buddyr in another question, I came across a little quirk I couldn't immediately sort out. I was building a string from the contents of a list box on a form, with the idea of filling a text box on a report and I wanted to insert CR between each item of the list using Chr(13), but that didn't work. I know that when entering text...

Hello - I am receiving the below error message when attempting to open a report. This database is used by approximately 20 users and only one user is having this problem (even I can't duplicate this error on my own PC). The command being used is DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview OR DoCmd.OpenReport...

I am running/coding update queries in MS Acess VBA 2002 and each update query asks the user to click "Yes or No" to verify they want to update the table. I do not want this user interaction (since there are alot of queries) How can I set the Display Alerts to FALSE (like in Excel) so that this box does not pop up asking the user if they...