Hi All
A simple problem no doubt!
I am trying to convert my Works database into an Access dB (which I have just bought). I cannot find any help on this anywhere?
Any help will be much appreciated
Thanks
Paul
I have a database with 12 tables,8 modules and 20 forms. But when I try to convert it to an MDE file it gives me an compilation error, that the size of the file is too large.
Can anyone tell me why??
Is there an easy way to convert an integer into time? What I want is for the person to enter in 0820 or even 820a and then convert it to 8:20 am. This is mainly to save keystrokes.
View 5 Replies View RelatedI am building a database using data imported from Excel workbooks. The dates in the workbooks are formatted as text in the YYYYMMDD format. Is there a way to convert this into date format during the import or after? I am pulling in a lot of different workbooks and trying to avoid having to reformat each individual workbook prior to importing them.
View 3 Replies View RelatedI have a problem converting text to a real date value so I can do some calculations. I have a query that brings in data from an external data source. It appears the data is stored in the external table in text format and looks like this:
20050902 15:40:41
I have tried CDate to convert the text to a date/time format, but no luck. Any ideas?
I have a CSV file and want to convert it in a text format with some filtered data and with some formatting. This is an everyday task for me. So I made a table and imported the data in to it by the command :
DoCmd.TransferText acImportDelim, "fo Import Specification", "fo", FileName:="C:UserswelcomeDesktopfo.csv", HasFieldNames:=True
Actually I have a column "SERIES", contains various series like "EQ", "BE", "DR", "BZ", "D1" and so on. And one more column with the dates having 4 / 5 current months dates and one next months date and one next to next month's date. And every date has got several thousand records.
now the issue is that : After importing these several thousand records, I want to export it but with a specific date and with a specific series.
The other thing is that, these dates change every month so if hard coded, the problem will occur the next month.
I use this code for export :
DoCmd.TransferText acExportDelim, "NewFnoSpec", "fnoquery", "C:UserswelcomeDesktopFO Output.txt", True
this code is working fine but when the month will change, the code won't work.
Can we have a date & series picker attached to this query, so it can export the records with the specified SERIES & DATE.
I tried putting a textbox on the form named TxtDate and in a Query ( Design mode ) under the date column, in criteria I have put [Forms]![Futures]![TxtDate] and after putting this line, the query becomes empty and no data is there.
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
I am exporting data from access 2007 to Excel 2007 using VBA code. I have a whole number, which I want displayed as whole number. But after the export, the number is using the 1000's seperator in Excel. So for example if my original number in access table is 12000, it is showing up as 12,000 in the excel file.It has something to do with the NumberFormat property. I have tried doing this but doesn't work.
objSheet.Range("A1:A7").NumberFormat = "General"
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
View 3 Replies View RelatedI have created a database but I would like it to be an exe. is this possible? if so, how???
I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem?
thanks
Hello Everyone,
First of all thanks alot for investing your valuable time in reading my query, I wonder if someone can kindly educate me on how to convert an access database.mdb file to an executable .exe file. Also is there a way to create an installation package to install the database to many Computers.
Thanks Again
Warm Regards,
Darno
hi guys!
i just wanted to find out how do i convert an mdf to access,
please help!
Kind Regards
phindile
I have a dbase that was created in access XP. We are in the process of upgrading to office 2003. For the most part the database works fine. However, I have 1 form that has a few fields that have conditional formatting
on them and when the form opens those fields flash very fast continuously all most like the tab key is being held down. No matter what I do I can't get it to stop. Has anyone seen anything like this and how do I make it stop?
jon
This is the error i get...
This error is usually associated with compiling a large database into an MDE file.* Due to the method used to compile the database, a considerable number of TableID references are created for each table.* The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
More information about this error message online.
My database is by no means big, is there any other way i can convert from mdb to mde?
Thanks
Den
Hi.
For years several agencies have used a database written and maintained in Access 97.
One adminstartor has both 97 and 200 on his computer and no problem. Until now, that is.
When I try copying a revised front end, and opening it, I get 'unrecogized database format' message.
My hunch i sthat said administartor accidentally opned the basck end with 2000 and converted it.
So, can the back end be unconveted/reverted back to 97?
Any other suggestions?
Russ
I have a problem converting access 97 mdb files into access 2000. There are multiple access databases that use a mdw workgroup on a network drive. I do have the ability to log on as an admin. Access 2000 is not letting me convert the files to the new format (telling me I don't have permission). The databases do have lots of forms, queries, macros and such.
Would the easiest method be to remove the userlevel security or is it possible to get around that? If I were to remove the user level security is it as simple as loggin in as admin, deleting all user account, granting all permissions to users and admin and removing the password?
Any help is much appreciated.
Hi All
I am currently compiling an Access DB to manage my work in progress, Payments due etc.
The DB is starting to work well and have requests from fellow contractors to purchase a copy (there are over 400 subcontractors in the group), with this in mind I have decided that when I complete the DB I will take it to a proffessional programmer and have it converted to a fully standalone programm.
My question: Is there a programm format that is preferable or would C# be the best option or is there a product out there that I could purchase and use.
Thanks in Advance
GeoffK
I've read alot on this, Tony Toews, Allen Browne and our own experts have put out lots of info.
I've started converting my dog straying database and have a weird result. This is split into front and back ends.
Result:
My PC Win XP Access 97 and 2003 works perfectly
PC 2 Win 2K Aceess 2003 ditto
PC 3 Win XP Access 97 and 2003
setup looks identical to mine no missing refeneces etc - No images will display in the image frame on the main form.
I have no hair left. Any ideas??
Hello,
I'm trying to get a way to creat a database of my phone messages (SMS).
I have them on a .txt file and I would like to create on ACCESS (or other program) the fields "Date:" "From:" "Message:", etc.
So, everytime I introduce a day, all sms sended on that day appears, or, when I introduce a Name, every message from that person, appear.
Is that possible? Of course that I want to convert it, not introduce one bye one because I have around 2000 messages...
Thank you very much
This is a example of the .txt file I have:
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 15:33
-----------------------------------------------------------
Hum que bom então. Tou com a minha amiga na praça da república. Vais ficar aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:59
-----------------------------------------------------------
Tas em casa?a mariana foi aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:52
-----------------------------------------------------------
Já tá?
================================================== =========
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 12:47
-----------------------------------------------------------
Desce tou no carro em frente ao mc donalds..
================================================== =========
I have time sheets from the past I need to enter but have found that some years the time punch minutes are given as if an hour equals 100 minutes not 60. Other years the minutes are given correctly. How do I format this field so that if I type 3.75 it will convert to 3.45 hours? Will I have to add another field to enter this and then convert to my field where hours and minutes are correctly entered? :confused:
View 2 Replies View RelatedHello,
Could someone tell me is it possible to convert a particular column from 0/-1 to show y/n instead? Its just a simple select statement I'm doing and I need a Y or N instead or numeric!
Thanks,
R:)
Hi here is the original code
MAX(IIf([Book]='C',[Score]," ")) AS CScore,
Max(IIf([Book]='C',[PercentileScore]," ")) AS CPercent,
Max(IIf([Book]='C',[PassFail]," ")) AS C,
Max(IIf([Book]='D',[Score]," ")) AS DScore,
Max(IIf([Book]='D',[PercentileScore]," ")) AS DPercent,
Here is what I thought may work, but it seems like there should be an easier way
Case when Max ([Book]) = 'C' then [Score] else null as CScore,
Case when Max([Book]) = 'C' then [PercentileScore] else Null as CPercent,
Case when Max ([Book]) = 'C' then [Passfail] else Null as C,
Case when Max([Book]) = 'D' then [Score] else Null as Dscore,
Case when Max ([book]) = 'D' then [PercentileScore] eslse Null as DPercent,
Thanks
K
I am trying to convert a whole number to a start time w/ no luck. Assuming "0" is 12:00 AM, I have a start minute of "480" which would in essence be 8:00 AM. Can anyone tell me if I can somehow convert this to time in my query? Thanks.
View 3 Replies View RelatedHi All,
I have a table that has fields that captures dollar amounts. I have these fields set to a default value of "0".
The tables are updated via a query that imports a csv file. Once the import process has finished, my table has blank values in some of the fields that capture dollar amounts.
If a field populated by the csv file is left blank, I would like for the field to show $0.00.
How would you recommend handling this?