Search results

Hi All, Wondering if this is possible? Attached is a subform snapshot that I am currently using. Instead of a tick for each field from the table I was wondering if a "X" can be displayed instead of a tick? This form is from a table that has a "Yes/No" field for each number. Part of a...

Hi All, Does anyone here know how ot access the "Group Memebership" of your profile? Robert88

Hi All, I have a database which contains all historical draws from our Tattslotto system here in Australia. I want to get some comments on the best way to tackle checking two tables as listed below. tblDrawn_No 'This is the table with drawn tattslotto numbers so only one row per draw...

Hi All, Another challenge to my life, reading a dat file from CD. I have looked at other posts on reading .dat files and it is clear that to import a dat file is not possible through the import of files.:eek: I have a standard file which for the purpose of the exercise I will call test.dat...

Hi All, I am wondering if it is possible using VBA to update using either an option group or check boxes as shown in the frmDefaultValue in the attached file to update two tables tblLabelNumber and tblMediaType. The form frmMedia contains two combo boxes. I am trying to use the form...

Hi All, I need help getting data from a group of unbound fields on a form to a table. Is this possible? Hopefully with VBA. Example of fields on form - frmLabel1Data txtClientName txtProjectNumber txtTypeofMedia txtPath1Files txtFile1NameFrom Example of fields in table - tblCDLabels...

Hi All, I hope someone can help me. I have a table here tblTemp with a field client. This table can have from 1 to 100 records at times as it keeps getting cleared for the purpose of this exercise. I also have a form frmLabel1Data with an unbound text box txtclient. I was hoping to get the...

Hi All, I have four tables that are part of a CD Labelling Database. They are used like a list to set default values within my database and all tables are not within any relationship. These tables and structure are; tblLabelNumber fldLabelNumber - Text fldDefaultLabelnumber - Yes/No...

Hi All, If anyone can help I would appreciate it. I have scanned the internet and this site to not much avail...... But however I did stumble across this code in another site which contains the following code; Private Sub CmdReadDBF_Click() DoCmd.TransferDatabase acImport, "ODBC", _...

Hi All, I have never done this and not sure if it is possible but thought I would ask. Is it possible to show within a window maybe, a print preview of a report on a Form? I am going to assume that the answer is no? But I could be wrong? Look forward to anyones input on this one.:p Robert88

Hi Everyone, I hope someone can help. I have a form with a combo boxes and a table with relevant list and additional field, fldDefaultDrive (Yes/No Field). Currently in order to set the default value, I have used the following code for each default; Private Sub Form_Load()...

Hi All, I am hoping soemone can help me? I have code which will allow me to access files and folders form a folder with various files and folders within it @ "C:\CD Data", eventually I will change the path to read a CD but temporarily the information is on my hard disk. The code below sends...

mso commands??? Hi All, Recently I asked about finding information from folders or in my case a CD. http://www.access-programmers.co.uk/forums/showthread.php?p=415218#post415218 Thanks to GHudson I managed to download the file attached in his comments, which I noticed has lost it link but...

To anyone that can help? Not sure if it is possible? I have managed to successfully import into a table non-delimeted data as seen in the link http://www.access-programmers.co.uk/forums/showthread.php?t=96996 the data went into fldDate(Datatype: Date), fldHours(Datatype Text) & fldMins...

I have been trying to import a txt file into a table. Doing it manually with import, using the Door Fob import specification and importing it into tblDoorFob table it is successful. I have written VBA for a button on a form frmReadDoorFob. Private Sub CmdReadFile_Click()...

I have created a button on a form in order to transfer text into a table tblPlanetarySystems from a file PlanetarySystems.txt. the code is as follows Private Sub CmdReadFile_Click() DoCmd.TransferText acImportDelim, , "tblPlanetarySystems", "C:\Planet\PlanetarySystems.txt", True End...

I was wondering if it is possible to be able to read a CD directory structure in as maybe a variable and ultimately reading it into a field in a table? If it is possible would more than likely chop and cut directory path up into smaller bits as the paths have a fixed length and each...

:confused: I was wondering if somebody can help with my default combo box problem? I have a secured database whereby users logon, which is used as a scratch pad for keeping track of Purchase orders. A Form frmUserInput with two relevant fields for this problem 1. User Initials txtUsersInitials...

:confused: I have been searching to the point now where I am now scratching my head, I hope someone can help....... I have a form(frmDailyBoatCatch) that contains information on daily boat catches (as I am a member of a fishing club). Currently the info from each boat is placed on the form...